I tried to have two sql cursor declarations and have separate sections to open, fetch & close these cursors. And based on the JCL PARM parameter, correponding section will be called. This is working. But i want to check if there is any better solution.
Thanks...
Search found 7 matches
- Fri Nov 25, 2011 3:23 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: DB2 CURSOR DECLARARTION in COBOL - > to be dynamic
- Replies: 3
- Views: 6432
- Thu Nov 24, 2011 5:52 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: DB2 CURSOR DECLARARTION in COBOL - > to be dynamic
- Replies: 3
- Views: 6432
DB2 CURSOR DECLARARTION in COBOL - > to be dynamic
Hi Friends, I need a clarification on my below query. For example: I have a program which generates a report on Employees of the organistion fetching the Employee number, Name & Age from table. Now i have a requirement to have instance of jobs, 1 would generate a report for the employees who are wor...
- Wed Nov 16, 2011 4:53 am
- Forum: TSO, CLIST & REXX
- Topic: Mainframe PS to Excel and mail it.
- Replies: 18
- Views: 32721
Thanks Guys.. Am no way expecting the code... I understand and believe in "No Pain No Gain" I am able to download the content as delimited file as .txt and would be able to import that into a excel.. And if i am mailing it as .xls i am facing the prob of one row in a PS appearing in one cell.. Note:...
- Tue Nov 15, 2011 8:00 pm
- Forum: TSO, CLIST & REXX
- Topic: Mainframe PS to Excel and mail it.
- Replies: 18
- Views: 32721
- Mon Nov 14, 2011 2:35 am
- Forum: TSO, CLIST & REXX
- Topic: Mainframe PS to Excel and mail it.
- Replies: 18
- Views: 32721
My requirement is to send the attachment as excel itself.. The results are to be sent to Business stake holders who needs the end result.. So i need to send the attachment as .xls file... I am able to send the content in mainframe dataset as excel spreadsheet, however each row in a dataset appears i...
- Sun Nov 13, 2011 9:08 pm
- Forum: TSO, CLIST & REXX
- Topic: Mainframe PS to Excel and mail it.
- Replies: 18
- Views: 32721
Thanks MrSpock & DikDude... I tried Excelxp tagset but i don think tat tagset is available for use. How do i check what are all the tagsets available... the way my data will look is Empno #Name #Age 1 #AAAAA #25 2 #BBBBB #26 Now i need this to be downloaded to a spreadsheet having values of Empno, N...
- Sun Nov 13, 2011 3:10 pm
- Forum: TSO, CLIST & REXX
- Topic: Mainframe PS to Excel and mail it.
- Replies: 18
- Views: 32721
Mainframe PS to Excel and mail it.
Hi Friends, I have a requirement to send the data present in a PS to a mail recipient as Excel. I would be executing a DB2 query and using a Selcopy to convert the SYSPRINT of SPUFI job into a PS which will have columns separated by '#' symbol. Now i need to conver this content into a excel and mail...