Author |
Message |
Topic: what is the best way to browse a screen? |
syam
Replies: 1
Views: 2342
|
Forum: CICS and Middleware Posted: Sun Dec 31, 2006 3:28 am Subject: what is the best way to browse a screen? |
Hi jctgf
How about TSQ and paging logic, Ideally suits for this situation. Write the records into TSQ
The steps ivolved in the process are
Declaring TSQ
01 TSQ-QUEUE. ... |
Topic: Dynamic Arrays |
syam
Replies: 5
Views: 4486
|
Forum: Application Programming Posted: Sat Dec 30, 2006 8:58 am Subject: Dynamic Arrays |
My working storage declarations for the array and another group element declarations are
05 WS-SEL-VALUE PIC 9(03).
05 WS-SEL-ARRAY. ... |
Topic: Dynamic sql select query |
syam
Replies: 5
Views: 2700
|
Forum: Database Posted: Thu Dec 28, 2006 10:17 am Subject: Dynamic sql select query |
Kolusu,
Execution is successful without declaring S2, Thank you very much for the efforts put up. |
Topic: Dynamic sql select query |
syam
Replies: 5
Views: 2700
|
Forum: Database Posted: Thu Dec 28, 2006 9:44 am Subject: Dynamic sql select query |
Kolusu,
Thank you now i got the things. Any how i made the design changes so that the progarm could accomadate for fixed list selct. I have browsed the ibm link http://publib.boulder.ibm.com/info ... |
Topic: Dynamic sql select query |
syam
Replies: 5
Views: 2700
|
Forum: Database Posted: Wed Dec 27, 2006 2:11 am Subject: Dynamic sql select query |
Kolusu,
Thanks for the info.After fetching the rows , the rows are moved into SQLDA, How to retrieve these values from SQLDA. |
Topic: Dynamic sql select query |
syam
Replies: 5
Views: 2700
|
Forum: Database Posted: Tue Dec 26, 2006 5:15 am Subject: Dynamic sql select query |
Hi,
I want to use Dynamic Sql Select Query in a cobol , DB2, CICS program, Please let me know the process and compiler options and any other issues to be taken care of.I want a practical program ... |
Topic: Select Duplicate Rows |
syam
Replies: 2
Views: 1831
|
Forum: Database Posted: Mon Nov 06, 2006 11:22 am Subject: Select Duplicate Rows |
Thank you  |
Topic: Select Duplicate Rows |
syam
Replies: 2
Views: 1831
|
Forum: Database Posted: Mon Nov 06, 2006 5:43 am Subject: Select Duplicate Rows |
I want to fetch all the values from a table say EMP_DONATIONS where emp-id's are present EMP_ID column more than once. I mean to say I want all the emd-id's which are present more than once in the tab ... |
Topic: Accessing Last But one element of TSQ |
syam
Replies: 4
Views: 2660
|
Forum: CICS and Middleware Posted: Tue Sep 19, 2006 7:08 am Subject: Accessing Last But one element of TSQ |
We can proceed in In this way, looks quite ok ,If no other better way is available we can proceed in this way |
Topic: Accessing Last But one element of TSQ |
syam
Replies: 4
Views: 2660
|
Forum: CICS and Middleware Posted: Wed Sep 13, 2006 9:50 am Subject: Accessing Last But one element of TSQ |
Hi,
Can we access last but one element ((n-1)th element) of TSQ,
I am not sur of the number of elements a TSQ contains.
Regards |
Topic: validation logic |
syam
Replies: 9
Views: 3897
|
Forum: Application Programming Posted: Mon Sep 11, 2006 1:20 am Subject: validation logic |
Thank you |
Topic: Meaining of <> in DB2 queries |
syam
Replies: 2
Views: 1618
|
Forum: Database Posted: Mon Sep 11, 2006 12:45 am Subject: Meaining of <> in DB2 queries |
Thank You |
Topic: ALLOCATE CURSOR ERROR MESSAGE |
syam
Replies: 2
Views: 3602
|
Forum: Database Posted: Mon Sep 11, 2006 12:42 am Subject: ALLOCATE CURSOR ERROR MESSAGE |
Kolusu,
Thank you , Got the thing (Shout ) and will use accordingly.
The links did helped me.
Cheers |
Topic: ALLOCATE CURSOR ERROR MESSAGE |
syam
Replies: 2
Views: 3602
|
Forum: Database Posted: Sun Sep 10, 2006 11:50 am Subject: ALLOCATE CURSOR ERROR MESSAGE |
PLEASE INTERPRET THE ERROR MESSAGE, WHAT IS THE MISTAKE I HAVE DONE
DSNH520I E DSNHSMUD LINE 5637 COL 15 THE OPEN STATEMENT FOR CURSOR "MY-CUR" IS INVALID BECAUSE THE CURSOR WAS ... |
Topic: Meaining of <> in DB2 queries |
syam
Replies: 2
Views: 1618
|
Forum: Database Posted: Sun Sep 10, 2006 11:46 am Subject: Meaining of <> in DB2 queries |
Hi,
What does <> stands for in db2 queries ex:
EXEC SQL
SELECT USER_NAME
, USER_ID
FROM MY_TABLE
WHERE SSN_NO <> '1'
... |
|