DSXchange

hi
Thanks for your quick reply .
This string cannot be null.

my quesition
position string[123 through 125] including decimals is numeric or ='n/a'
then return the string .
how can me do in datastage.
thks

Hi
I have a string length of 288 characters.
I have some conditions like if position in string[122,125] = 'xyz'
then statement 1 else statement 2.

my question is can we sue incolumn.[122,125] tp return string
at this position.
thks

Hi I am starting a new project and they told that they use only unix to sequence and run the jobs.I dont know why they are not using Datastage job sequence or any third party tools(Appworx).I want to know where i can find more information about this like study material ,Docs . Thank you very much fo...

HI
i want to know how i can sequence and run the server jobs through UNIX.
thks

Hi Thanks for your reply.I am using same i/p data .when i tried to use your logic i am getting following error Inserted value too large for column, row rejected. Datastage is taking all lines at a time and trying to insert in 132 char feild length in o/p. but i want to take each line seperatly and i...

hi
thanks for your reply.i dont think it may work.I want to increment the counter(line no) if there is change in key column or if it is a next line.
how can i tell to datastage .share your thoughts.
thks

Hi sorry for confusion.routine worked fine. Now my question is i have input data key column MSC txt k1 ABC--- DEF---- GHI--- k2 123 like this i have 10 lines each has 132 char in length. now i want to insert this in a table where each line inserted and line number is incremented by 1. o/p is key col...

HI This is my dample data . key inputcolumn k1 abc def ghi k2 jkl o/p linenumber o/pcolumn 1 abc 2 def 3 ghi 1 jk1 [/code] thank you

HI
i mean depend on how many lines you have in Input (say 10 ) i have to generate 10 lines by creating line numbers and increasing line number by 1 in o/p and then insert each line to correspondong line in O/p.
thks

Hi
I worked with routine it worked fine.i just added while loop to it.
now the problem is how to tell the datastage to insert this 10 lines each 132 char in length into a line,next lines.. in table .
I am getting warning value too large for column.
share your veiws.
thks

hi
Thank you very much for your quick reply.
thks

Hi
I have a input colunm with varchar2(255).but in my out put column length is varchar2(132).I have to insert first 132 characters and if it exceeds this length back trace to last space and move the remaining entire text to next line.
pl let me know how we can do this in datastage.
thks

hi thanks for your reply.still i am not able to find the solution for this problem.if i got PRE RECORD i should compare with next row not the immediate previous record. can you please share your thoughts to solve this problem thks <i have a bussiness conditon that if a row contains PRE then compare ...

hi
i have a bussiness conditon that if a row contains PRE then compare with below one and if it contains POST compare with above row.
i am using rowcompare to compare with previous value .
my question is how to compare with next row.
do we have any rowcomparenext ---.
pl share your thoughts.
thks

Hi It is not in sort stage.but in seq file. In one of the column feild length is 5 but there is only one value. and i passed this through stage variable change(Char(feild +64) , "@", " "). but if you trim before sending through stage variable it works fine. thanks for your help t...