Search found 5 matches
- 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...
- 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...
- 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...
- 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
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
- 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
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