Search found 537 matches

by Natarajan
Fri Mar 27, 2009 9:10 pm
Forum: COBOL
Topic: alphanumeric to numeric value padding with ZEROS in COBOL
Replies: 11
Views: 28702

COBOL FUNCTION NUMVAL INSPECT REPLACING

Method 1) In cics-bms programs In cics programs.. you can do this by coding appropriate picture clause in BMS maps ( PICOUT attribute ) , if your work is to display the numeric data with padding zeros. Method 2) applies to any COBOL program Here is the basic solution for this. MOVE ' 345 ' TO WS-ALP...
by Natarajan
Fri Mar 27, 2009 4:06 pm
Forum: COBOL
Topic: alphanumeric to numeric value padding with ZEROS in COBOL
Replies: 11
Views: 28702

Let us know , if you are still facing the issue.
by Natarajan
Fri Mar 27, 2009 3:43 pm
Forum: VSAM - File system
Topic: CI Splits
Replies: 2
Views: 4916

CI Split

It is not exactly half the number of records... Approximately half of the records from the full CI will moved into free CI's . Once the CI Split has completed, the new record that caused the split to occur can then be inserted into the original CI.
by Natarajan
Thu Mar 26, 2009 10:07 pm
Forum: VSAM - File system
Topic: How can i delete records form a VSAM file.
Replies: 9
Views: 22710

vsam cluster REPRO REUSE option

If you want to delete all the records in VSAM without deleting VSAM. Use following methods. method 1) Use COBOL program to do this. method 2) Define your VSAM file with REUSE option YES. after that everytime you want to empty the the VSAM file. Use IDCAMS REPRO with REUSE option to copy empty file t...
by Natarajan
Thu Mar 26, 2009 9:45 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Load replace/resume, REORG related query.
Replies: 1
Views: 6117

Hi paheli,

In our shop, we do LOAD REPLACE & LOAD RESUME... but we dont do REORG.
May be DBA's does that in a specified frequency. As a programmer we dont do that...
by Natarajan
Wed Mar 25, 2009 2:17 pm
Forum: OTHER SUBJECTS
Topic: Want to become a db2 DBA (Mainframes)
Replies: 2
Views: 5992

That is a good decision. You may need to start with db2 dba certifications.
by Natarajan
Wed Mar 25, 2009 12:22 pm
Forum: INTERVIEW QUESTIONS
Topic: How to check that who is holding the dataset
Replies: 4
Views: 13323

Use 'WHOHAS' command infront of that dataset.
by Natarajan
Tue Mar 24, 2009 4:31 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Variable length field from a file using SORT
Replies: 15
Views: 28407

DFSPRT INCLUDE OUTREC FINDREP INOUT

Please check this sort card... i did not tested this card.. //SYSIN DD * SORT FIELDS=COPY INCLUDE COND=(1,6,CH,EQ,C'Loaded') OUTREC FINDREP=(INOUT=(C'LOADED',C'',C'rows into the database',C'')) /* It will place required record into output file. by replacing the string with sp...
by Natarajan
Tue Mar 24, 2009 2:32 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Variable length field from a file using SORT
Replies: 15
Views: 28407

In that case.. There should be a standard string like 'NO OF RECORDS LOADED'
do you have this kind of string in that line along with your numeric field.
by Natarajan
Tue Mar 24, 2009 2:25 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Variable length field from a file using SORT
Replies: 15
Views: 28407

is it delimited file?. example shown below.

12,343435,343527664
by Natarajan
Thu Mar 19, 2009 2:16 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: UPDATE
Replies: 1
Views: 2957

I did not understand the question fully. But here is my answer, as per my understanding... before fields updation, you need take screen shot of field value. after field updtion, verify with old values. i gave answer in regard to testing. if above answer is not related to your question. let me know, ...
by Natarajan
Thu Mar 19, 2009 12:57 pm
Forum: VSAM - File system
Topic: Trying to delete/define a VSAm, but VSAM is in use
Replies: 10
Views: 19092

IDCAMS REPRO

Following is the jcl which i am using.. .for repro... may be useful to you. //RAL5280F EXEC PGM=IDCAMS //********************************************************************** //INFILE DD DUMMY //VSAMFILE DD DSN=ZSD.DEV.VSAM.SWR.$IAM,DISP=SHR, // AMP=('BUFNI=1','BUFND=5') //SYSPRINT DD SYSOU...
by Natarajan
Wed Mar 18, 2009 6:27 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Check Pending
Replies: 1
Views: 3223

Is possible... if you give ENFORCE NO option while loading data.
by Natarajan
Tue Mar 17, 2009 9:49 am
Forum: JCL
Topic: HOw to run jcl at particular date and time?
Replies: 3
Views: 8905

as per my knowledge, we need to use CA-7 tool to set a jcl to execute in a specified time. OR any other similar tool.
by Natarajan
Fri Mar 13, 2009 8:42 am
Forum: General Discussion
Topic: MS - invites you to the Community TechDay
Replies: 1
Views: 3607

MS - invites you to the Community TechDay

Go here to register to attend the session -
http://www.microsoft.com/india/ctd-itpro/


Mumbai - 7th March

Banglore - 14th March

Pune - 21st March

Hyderabad - 28th March

Chennai - 11th April