How to get rid of new line return in Datastage basic code
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 76
- Joined: Mon Mar 05, 2007 9:26 pm
- Location: Malaysia
How to get rid of new line return in Datastage basic code
Hi all,
I've a shell script to get date from table, then print it to datastage.
In shell script the date returned is fine but when it went to datastage, it returned date follow by a new line. Thus making the child job inherit the parameter(date) to a null value. Suspect it takes value at the new line which is null.
I've tried trim, and substring but doesnt seem working anyway.
Is there any solution to get rid of newline returned?
Thanks in advance for your help.
agatha
I've a shell script to get date from table, then print it to datastage.
In shell script the date returned is fine but when it went to datastage, it returned date follow by a new line. Thus making the child job inherit the parameter(date) to a null value. Suspect it takes value at the new line which is null.
I've tried trim, and substring but doesnt seem working anyway.
Is there any solution to get rid of newline returned?
Thanks in advance for your help.
agatha
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 76
- Joined: Mon Mar 05, 2007 9:26 pm
- Location: Malaysia
-
- Participant
- Posts: 76
- Joined: Mon Mar 05, 2007 9:26 pm
- Location: Malaysia
-
- Participant
- Posts: 76
- Joined: Mon Mar 05, 2007 9:26 pm
- Location: Malaysia
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 76
- Joined: Mon Mar 05, 2007 9:26 pm
- Location: Malaysia