How Fetch the Records....

naveen19 · Post by **naveen19** » Mon Feb 11, 2008 12:33 am

Hi Folks,

I have Requirement, i have to fetch two column records from the database(DB2) and write that into a dataset by using Shell Script or Routines.... is it possible..

Thanks in Advance

Regards
Naveen.K

ArndW · Post by **ArndW** » Mon Feb 11, 2008 2:45 am

Yes, it is possible. I am not going to ask you why you aren't doing this in a DataStage job as you have hopefully thought of that.

You can execute a shell program and do your DB2 connect and query routines from there.

naveen19 · Post by **naveen19** » Mon Feb 11, 2008 3:46 am

ArndW wrote:Yes, it is possible. I am not going to ask you why you aren't doing this in a DataStage job as you have hopefully thought of that.

You can execute a shell program and do your DB2 connect and query ...

Hi Arndw,

Thanks for ur reply, can u share any of the scripts or any tips to do that,so that it will be very helpful for me

Regards
Naveen.k

ArndW · Post by **ArndW** » Mon Feb 11, 2008 3:48 am

Naveen,

what have you tried so far?

p.s. "ur" and "u" are not valid forms of "your" and "you"; this isn't an SMS site.

naveen19 · Post by **naveen19** » Mon Feb 11, 2008 4:05 am

ArndW wrote:Naveen,

what have you tried so far?

p.s. "ur" and "u" are not valid forms of "your" and "you"; this isn't an SMS site. ...

i have retrieved the data from db2 with help of the script, and i dont how to write in the Sequential file or dataset..

p.s. you can stopped by saying "ur" and "u" are not valid forms of "your" and "you"; and not "this isn't an SMS site. ..."

naveen19 · Post by **naveen19** » Mon Feb 11, 2008 4:09 am

ArndW wrote:Naveen,

what have you tried so far?

p.s. "ur" and "u" are not valid forms of "your" and "you"; this isn't an SMS site. ...

i have retrieved the data from db2 with help of the script, and i dont how to write in the Sequential file or dataset..

p.s. you can stopped by saying "ur" and "u" are not valid forms of "your" and "you"; and not "this isn't an SMS site. ..."

ArndW · Post by **ArndW** » Mon Feb 11, 2008 4:12 am

The script can write straight to a sequential file by you cannot do that to a dataset. If you need to write into a dataset then you should do everything in a job DB2 -> DataSet.

naveen19 · Post by **naveen19** » Mon Feb 11, 2008 4:19 am

ArndW wrote:The script can write straight to a sequential file by you cannot do that to a dataset. If you need to write into a dataset then you should do everything in a job DB2 -> DataSet. ...

Can you provide any sample script which will help me a lot which writes that data directly to sequential file

Regards
Naveen.K

naveen19 · Post by **naveen19** » Mon Feb 11, 2008 4:23 am

ArndW wrote:The script can write straight to a sequential file by you cannot do that to a dataset. If you need to write into a dataset then you should do everything in a job DB2 -> DataSet. ...

Can you provide any sample script which will help me a lot which writes that data directly to sequential file

Regards
Naveen.K

ArndW · Post by **ArndW** » Mon Feb 11, 2008 5:19 am

Naveen - I am confused. You stated that you have written a script to retrieve the DB2 data; just add a redirector such as ">> textfile.txt" in order to create a sequential file from the output.

Are you sure you wish to make it complicated and use a script and not do this in DataStage job with just 2 stages?