Search found 537 matches

by Natarajan
Sun Mar 08, 2009 5:42 pm
Forum: JCL
Topic: GDG
Replies: 2
Views: 2760

Raj - If this is a interview question, please post them in INTERVIEW QUESTIONS forum. one use i can say is - it is easy to track daily reports on one GDG name. if you use file name, when the same executed, files created before should get deleted. we loose the data. In the case of GDG , we can mainta...
by Natarajan
Fri Mar 06, 2009 3:22 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Urgent : query to update a table referencing another table
Replies: 1
Views: 2664

your query will work... you want us to help in making a simple query.
by Natarajan
Fri Mar 06, 2009 1:03 pm
Forum: CICS
Topic: CICS question pseudo-conversational
Replies: 1
Views: 2961

As i know, cics programs always pseudo-conversational.... i.e, it wont wait for users response. CICS programs fired by user request and gives the response and end. When CICS programs uses techniques like TSQ/ TDQ/COMMA AREA to trasfer data between transactions/ between two cics programs, they apear ...
by Natarajan
Thu Mar 05, 2009 10:14 am
Forum: ABEND CODES / ERROR CODES
Topic: User Abend 3057
Replies: 4
Views: 12823

U3057 Explanation: This abend occurs when an application program attempts to connect to an external subsystem and a connection is not established. One of the following conditions can be the cause of the abend: - The SSM execute parameter was not specified for the control region defining the external...
by Natarajan
Wed Mar 04, 2009 5:00 pm
Forum: JCL
Topic: Deleting a PS when the higher qualifier is mentioned
Replies: 2
Views: 4977

i dont think it is possible. any answers from experts.
by Natarajan
Tue Mar 03, 2009 3:01 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Serious Data Problem Help Needed!!
Replies: 1
Views: 2846

low values in db2

some suggestions from my side. 1. < not sure> DB2 May treat low values as null. in that case we can easily replace low values with some value. OR 2. unload data from tables. using cobol program replace low values in the the files and reload them into tables. In cobol we have keyword like LOW-VALUES.
by Natarajan
Tue Mar 03, 2009 12:53 pm
Forum: JCL
Topic: Passing parm in Syncsort
Replies: 4
Views: 6999

That should be fine. I dont see any issue.
by Natarajan
Mon Mar 02, 2009 11:02 am
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Insert
Replies: 2
Views: 2628

Using cobol PERFORM you can add multiple rows into db2 table... i.e, by calling DB2 INSERT statement mutiple times. other way is... using DB2 INSERT INTO... SELECT statement. where SELECT statement return the no of rows.. those many no of rows will be passed to INSERT statement. It look like a inter...
by Natarajan
Mon Mar 02, 2009 10:57 am
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Update using where exists
Replies: 4
Views: 5629

thanks.
by Natarajan
Sat Feb 28, 2009 12:36 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Need Help in Updating with Current Timestamp
Replies: 2
Views: 5833

Use following sql in the main program to get timestamp.

EXEC SQL
SET :CURRENT-DT-TM = CURRENT TIMESTAMP
END-EXEC.

pass CURRENT-DT-TM to sub-program.
by Natarajan
Fri Feb 27, 2009 3:33 pm
Forum: JCL
Topic: RESTART
Replies: 2
Views: 2865

What i understand from your query is you want to restart from a step. but, i did not get what is your question over there. can you elobrate it.
by Natarajan
Fri Feb 27, 2009 3:09 pm
Forum: JCL
Topic: PROC
Replies: 4
Views: 4673

i never tried this, but, my guess is we can call proc from another proc.
we may need to use same line which we use in job for calling proc.

EXEC PROC=procname.
by Natarajan
Fri Feb 27, 2009 10:43 am
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Non Db2 calls Db2 , how to run ?
Replies: 1
Views: 2910

I never tried this... but i got info from my friend .... please try.

We dont required P1 on the plan.

use the following card while running these modules.

DSN SYSTEM(<your database system>)
RUN PROGRAM(Non-DB2 Program) PLAN(calling db2 module name)
END
by Natarajan
Fri Feb 27, 2009 10:34 am
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Update using where exists
Replies: 4
Views: 5629

Hi Pete,

can you update us, what is that different method.
by Natarajan
Thu Feb 26, 2009 7:53 pm
Forum: JCL
Topic: Passing Parameter from JCL
Replies: 4
Views: 4782

instead of * , you can use DSN=filename.