Search found 7 matches

by dichandr
Fri Nov 25, 2011 3:23 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: DB2 CURSOR DECLARARTION in COBOL - > to be dynamic
Replies: 3
Views: 4903

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...
by dichandr
Thu Nov 24, 2011 5:52 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: DB2 CURSOR DECLARARTION in COBOL - > to be dynamic
Replies: 3
Views: 4903

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...
by dichandr
Wed Nov 16, 2011 4:53 am
Forum: TSO, CLIST & REXX
Topic: Mainframe PS to Excel and mail it.
Replies: 18
Views: 25975

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:...
by dichandr
Tue Nov 15, 2011 8:00 pm
Forum: TSO, CLIST & REXX
Topic: Mainframe PS to Excel and mail it.
Replies: 18
Views: 25975

Thanks Dikdude...
Can you please provide sample data to refer?
by dichandr
Mon Nov 14, 2011 2:35 am
Forum: TSO, CLIST & REXX
Topic: Mainframe PS to Excel and mail it.
Replies: 18
Views: 25975

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...
by dichandr
Sun Nov 13, 2011 9:08 pm
Forum: TSO, CLIST & REXX
Topic: Mainframe PS to Excel and mail it.
Replies: 18
Views: 25975

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...
by dichandr
Sun Nov 13, 2011 3:10 pm
Forum: TSO, CLIST & REXX
Topic: Mainframe PS to Excel and mail it.
Replies: 18
Views: 25975

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...