MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Search found 22 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: what is the best way to browse a screen?
syam

Replies: 1
Views: 2342

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: Database   Posted: Mon Nov 06, 2006 11:22 am   Subject: Select Duplicate Rows
Thank you Smile
  Topic: Select Duplicate Rows
syam

Replies: 2
Views: 1831

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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' ...
 
Page 1 of 2 Goto page 1, 2  Next
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group