How Fetch the Records....
Moderators: chulett, rschirm, roy
How Fetch the Records....
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
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
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.
You can execute a shell program and do your DB2 connect and query routines from there.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Hi Arndw,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 ...
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
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.
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
i have retrieved the data from db2 with help of the script, and i dont how to write in the Sequential file or dataset..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. ...
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. ..."
i have retrieved the data from db2 with help of the script, and i dont how to write in the Sequential file or dataset..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. ...
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. ..."
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
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 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
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?
Are you sure you wish to make it complicated and use a script and not do this in DataStage job with just 2 stages?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>