Applying Loop in Datastage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 48
- Joined: Mon Oct 08, 2007 7:12 pm
- Location: Sydney
Applying Loop in Datastage
Hello,
I have an requirement where i need to apply loop,
Can it be done through datastage Enterprise edition.
Thanks in Advance,
I have an requirement where i need to apply loop,
Can it be done through datastage Enterprise edition.
Thanks in Advance,
Regards
Naveen Kandukuri
Naveen Kandukuri
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 48
- Joined: Mon Oct 08, 2007 7:12 pm
- Location: Sydney
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
I have posted a parallel routine which exactly does what you need. You can find the solution in THIS post.
Main highlights of this C++ function are:
Main highlights of this C++ function are:
-->Creates and writes on a text file for each record.
-->You can dynamically pass your file path, file name and extension and also the records to be written into the file.
-->Records can be of different metadata.
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
-
- Participant
- Posts: 48
- Joined: Mon Oct 08, 2007 7:12 pm
- Location: Sydney
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I'd use a server job and write to a Type 19 hashed file. Only 30 lines - sheesh! The server job would be done before the parallel job had even gotten started.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
OP didn't say only 30 rows
Can't see Jose or U's post in this thread
Can't see Jose or U's post in this thread
tech_savvy wrote:If there are 30 rows in the output i am expecting 30 files.
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
Upto 10 million!! Love to race!
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
The link is fine. You're probably logged in to 'dsxchange.com' and he linked to 'www.dsxchange.com'. Copy the link, paste it into the address bar and remove the www, see if it works then.tech_savvy wrote:Thanks for your reply, The solution page U have given is not opening I think the page might have been expired.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers