MVSFORUMS.com

radkrish · Beginner Joined: 12 Aug 2005 Posts: 102 Topics: 19

Iam running a SELECT query in the JCL.

When i open the the dataset,it shows
sqlcode 00
5 rows retrieved
....
...
and then the value of the fetched field.

I need the data of fetched fields alone in the o/p dataset and don't need the sql informations.
how do i get it?

radkrish · Beginner Joined: 12 Aug 2005 Posts: 102 Topics: 19

Adding to the above,In the where clause i need the system date.Also pls let me know the parameter to get it in the query.

kolusu · Posted: Sun Aug 21, 2005 2:30 am Post subject:

radkrish,

Please search before posting. Check this link

http://mvsforums.com/helpboards/viewtopic.php?t=4054&highlight=unload

radkrish · Beginner Joined: 12 Aug 2005 Posts: 102 Topics: 19

When i run this query,it always gives this warning message.
.JAAA 0 DSS8094A - DB2 USING DSN RETRY DEFAULT
JCL submission was successfull.but why was it so?

Edit : Found that its an advisory message.

stalin · Beginner Joined: 22 Aug 2005 Posts: 23 Topics: 4

Dear kollsu,

i have a flat file with

record length : 80
block size :800
record format :FB

we are not sure of how many records it has. But we need to insert a value
ABC1 in the first record in 10th position .
the next record Should have the value ABC2 in the same position and so on.
for exp.

rama 2345 ABC1
ravi 4566 ABC2
KRIS 5677 ABC3
.
the program should let us know what was the last value got inserted in that particular position.

can you please help me on this

THE LENGTH OF THE INSERTED FIELD IS 4.
.

kolusu · Posted: Wed Aug 24, 2005 7:54 am Post subject:

stalin · Beginner Joined: 22 Aug 2005 Posts: 23 Topics: 4

Yes it has to make a phone call and say this to me

kolusu · Posted: Thu Aug 25, 2005 6:47 am Post subject:

stalin · Beginner Joined: 22 Aug 2005 Posts: 23 Topics: 4

Dear Kolusu, lets stop fighting for a while and i kindly request you to help me out...i will explain my problem clear, to my level best...

i have a dataset with

Record Format : FB
Record Length : 80
Block Size :800

we are not sure of the total number of records.
i need to insert a 8 digit Alpha numeric character(which we call it as TAG) in 10th position in each of the record.

For example:

arun abc12345
ramesh abc12346
kumar abc12347
.
.
.ravi abc12349
.raghu abc12350 (please see the tag value gets increased by 1).

ASSUMPTION: THE TOTAL NUMBER OF RECORDS DOES NOT EXCEED 1000.

so,if we give the initial tag value , it has to tag all the records and finally it has to let the programmer know the last value of the Tag that has been inserted.

hope i made you understand my problem. suggest me whether it can be done with utilities in JCL or we need to go for a Cobol program. i would like to do it with the utilities rather than cobol...looking forward for your reply with lots of hope.

Thanks
stalin.

kolusu · Posted: Mon Aug 29, 2005 3:57 am Post subject:

Cogito-Ergo-Sum · Posted: Mon Aug 29, 2005 9:56 am Post subject:

Kolusu,
As per Stalin's sample output, the running number is not having leading zeroes, whereas your step will put the sequence number with leading zeroes.

Also, he says,

kolusu · Posted: Mon Aug 29, 2005 10:06 am Post subject:

stalin · Beginner Joined: 22 Aug 2005 Posts: 23 Topics: 4

Dear kolusu, thanks for your solution. your program worked good . i made some more modification in the program thats suits my exact requirement. i will be back soon withsome more quries.

Warm regards.

Stalin