Hi,
Can anyone help me on this problem,
I have a requirement to pass a Tab delimiter as a parameter in the run time.I cannot use a Char(009) to pass as a parameter.So, What should i do on the same.Should i use a Tab as the default value in the job parameter..??
Thanks and Regards!!
:D
Tab delimited related
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 5
- Joined: Tue May 24, 2005 9:00 pm
- Location: Mumbai
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Can't readily be done in a parallel job if you want to use a Sequential File stage to read columns based on a schema; the record delimiter character and final delimiter character can not be substituted with job parameters in this stage.
Looks like you're trying to rewrite a server job in the parallel world!
You can still read the entire line as a single VarChar, then use a Transformer stage to parse it using Field() functions. If you do that, you can use a job parameter reference as the second argument to the Field() function.
Looks like you're trying to rewrite a server job in the parallel world!
You can still read the entire line as a single VarChar, then use a Transformer stage to parse it using Field() functions. If you do that, you can use a job parameter reference as the second argument to the Field() function.
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: 5
- Joined: Tue May 24, 2005 9:00 pm
- Location: Mumbai
Hi ray,
Thanks for that..
But my actual requirment is that..My source from a crystal report.I have to concatenate two fields with a tab delimiter which should be passed at runtime (i.e. as a parameter).This run time delimiter should also be used for checking in the later columns...
Thanks and Regards!
Thanks for that..
But my actual requirment is that..My source from a crystal report.I have to concatenate two fields with a tab delimiter which should be passed at runtime (i.e. as a parameter).This run time delimiter should also be used for checking in the later columns...
Thanks and Regards!
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I haven't tried this in DataStage but in many Windows applications you can use Ctrl-Tab to insert a tab where a regular Tab would move you to the next field.
Once you upgrade to 7.5 you will be able to use any expression in a Job Activity in a job sequence and therefore will be able to use Char(9) to deliver the tab character to the job parameter.
Once you upgrade to 7.5 you will be able to use any expression in a Job Activity in a job sequence and therefore will be able to use Char(9) to deliver the tab character to the job parameter.
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.