Search found 5 matches

by charigln
Thu Aug 14, 2014 6:44 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: How to Select and display the column data from Inner queries
Replies: 1
Views: 3321

How to Select and display the column data from Inner queries

Hi, I want to Display the data from Inner queries of co-related sub query. Below is what I wish to do... Select Emp1 from EMP where empcode IN (select empcd from DEPT where Empfrstname like 'Sures%'); I want to add empcd from DEPT table to be displayed along with Emp1 of EMP table, I don't want to d...
by charigln
Mon Jun 30, 2014 1:53 pm
Forum: EASYTRIEVE
Topic: Easytrieve Report Doubt,please clarify
Replies: 5
Views: 6699

If we use a Title instead of Line then there will be a space line introduced by default which is not required in my case...If I use Title, Report will look like below... REPORT 05 MY QUERY MODULE - title1 REMARK LIST - title2 SNO ACCT NO ERRORS - Title3 1 564535 ACCT NUMBER NOT FOUND - line1 Is ther...
by charigln
Fri Jun 27, 2014 8:33 am
Forum: EASYTRIEVE
Topic: Easytrieve Report Doubt,please clarify
Replies: 5
Views: 6699

Easytrieve Report Doubt,please clarify

Hi, I need code for accomplishing below requirement...Below is my report REPORT 05 MY QUERY MODULE - title1 REMARK LIST - title2 SNO ACCT NO ERRORS - line1 1 564535 ACCT NUMBER NOT FOUND - line2 I want this first line (SNO ACCT NO ERRORS ) to be printed once on every page I want second line(1 564535...
by charigln
Thu May 22, 2014 2:32 pm
Forum: EASYTRIEVE
Topic: Assignment of single value multiple times
Replies: 4
Views: 9440

See this also...

Hey,

I will take care of the variable in program. We were trying this but not compiled yet ...

MOVE '9' TO WS-VAR FILL '9'

Hope above works... share your thoughts...

Regards,
srini
by charigln
Thu May 22, 2014 12:12 pm
Forum: EASYTRIEVE
Topic: Assignment of single value multiple times
Replies: 4
Views: 9440

Assignment of single value multiple times

Hi,

I need to Move value 9's to variable WS-VAR which has length of 25 bytes, How do I do it in EasyTrieve?

WS-VAR should completely filled with 9's.

Regards,
Srini