Search found 17 matches

by santhosh kumar
Mon Mar 26, 2012 1:50 pm
Forum: COBOL
Topic: Please clarify on the REDEFINES doubt..
Replies: 2
Views: 3744

Please clarify on the REDEFINES doubt..

Hi, I have a doubt on redefines. Can we redefines a group item with the data item as shown below. Here WS-FIELD3 is a group item, and WS-FIELD2 is the data item. Here my doubt is can i redefines WS-FIELD3 group item with the WS-FIELD2 data item. please advise me, whether the following example is cor...
by santhosh kumar
Mon Mar 05, 2012 11:33 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: counting the no. of records through query
Replies: 2
Views: 4322

counting the no. of records through query

Hi, My problem is. Counting the number of records from table. When we counting the records we need to count one for same duplicate records. Example: Table :Emp EmpNo: 100 101 101 101 102 102 103 104 When we count the above records count should be 5. Why because 100 are 1, 101 are 3, here instead of ...
by santhosh kumar
Tue Jan 03, 2012 2:08 pm
Forum: COBOL
Topic: Suprressing the duplicate data at the time report generatio
Replies: 2
Views: 4314

Suprressing the duplicate data at the time report generatio

Hi, i am working on the report generation. In report generation, i am facing the problem. Ie., when i generate the report i have to follow following conditions. the report will suppress duplicate bank id's, bank names, bank types and main bank id. when a new page is printed these fields will be disp...
by santhosh kumar
Thu Dec 08, 2011 12:34 pm
Forum: JCL
Topic: How to schedule a program to run once per day around 5 a.m
Replies: 3
Views: 5275

thanks for your reply..
by santhosh kumar
Wed Dec 07, 2011 1:47 pm
Forum: JCL
Topic: How to schedule a program to run once per day around 5 a.m
Replies: 3
Views: 5275

How to schedule a program to run once per day around 5 a.m

Hi,

Could you please advise me how to schedule a program to run once per day around 5 a.m using jcl..

Please advise me.. i will be look for your reply..

Thanks!
by santhosh kumar
Thu Nov 10, 2011 4:42 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: how to describe a table in spufi
Replies: 5
Views: 8997

Use the below query for describe the table

SELECT DISTINCT(NAME),COLTYPE,LENGTH FROM SYSIBM.SYSCOLUMNS WHERE TBNAME='XXXXX';

Where XXXXX= Your table name..

Try with the above query..
by santhosh kumar
Wed Oct 05, 2011 5:02 pm
Forum: ENDEVOR, COOLGEN , PANVALET and CA-7
Topic: how to identify the errors in pgm after compiling in endevor
Replies: 2
Views: 7380

ok dikdude,

Thanks for the quick reply..
by santhosh kumar
Tue Oct 04, 2011 10:16 am
Forum: ENDEVOR, COOLGEN , PANVALET and CA-7
Topic: how to identify the errors in pgm after compiling in endevor
Replies: 2
Views: 7380

how to identify the errors in pgm after compiling in endevor

Hi, i compiled a cobol-db2 program using endevor. after compile it showing some errors. Here my question is how to identify the error position in cobol program after compiling the program in endevor. Please see the following messages, the following information relating to the errors to my program. w...
by santhosh kumar
Mon Sep 26, 2011 12:25 pm
Forum: ENDEVOR, COOLGEN , PANVALET and CA-7
Topic: program compilation process in endevor
Replies: 5
Views: 10462

Hi,

i compiled a program in ENDEVOR. I got some errors on that program. Could you please advise, me how to view the errors in program on ENDEVOR.

i will look for your reply..

in advance thanks..
by santhosh kumar
Thu Sep 15, 2011 6:22 pm
Forum: ENDEVOR, COOLGEN , PANVALET and CA-7
Topic: program compilation process in endevor
Replies: 5
Views: 10462

program compilation process in endevor

Could you please advise me, how to compile a new cobol program in ENDEVOR. and also let me know how to view errors in endevor, if i got on that program.. could you please provide with screen shots.. With the screen shots, i can understand perfectly... thanks in advance.. i will look for your reply..
by santhosh kumar
Tue Sep 13, 2011 11:54 am
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: data not loading properly into table from file using LOAD ut
Replies: 3
Views: 6254

data not loading properly into table from file using LOAD ut

Hi ,
i am trying to load the data from flat file to db2 table. But i couldn't loading the data properly. some data is truncating when i am loading the data into table.
by santhosh kumar
Mon Sep 12, 2011 6:32 pm
Forum: JCL
Topic: DCB parameter
Replies: 8
Views: 13657

Hi anuj,

Thanks for the reply..

Yes, I am talking about the Sort-work files

Thanks!
by santhosh kumar
Mon Sep 12, 2011 1:52 pm
Forum: JCL
Topic: solve SPANINC=RC16
Replies: 4
Views: 8321

Hi Frank Yaeger,

Thanks for the reply,

I have a doubt, What is the RECFM for the file, when we load the data from file to db2 table using LOAD utility.

Could you please give me the reply, i will look for your reply,,

thanks!
by santhosh kumar
Fri Sep 09, 2011 2:28 pm
Forum: JCL
Topic: solve SPANINC=RC16
Replies: 4
Views: 8321

solve SPANINC=RC16

Hi, Could you please explain what is SPANINC, when i am loading the data from the file to db2 table using LOAD utility in JCL i am getting SPANINC=RC16 in the SYSOUT spool. I hope with this, i am unable to load the data properly from file to table... ie., part of the data loading into the table prop...
by santhosh kumar
Thu Sep 08, 2011 6:53 pm
Forum: JCL
Topic: DCB parameter
Replies: 8
Views: 13657

thanks MrSpock

one more thing, when i am sorting. if i dont declare DCB parameter for temporary datasets. what will happen.

Please advise me on this..

Thanks in advance!