DSXchange

hi,
could you please help me out with the following problem. iam getting an error "This job has no design time information" when iam trying to compile the job.what can this be due to.
Any help would be appreciated
Ravi

hi kaps, i used the expression FIELD(DSLink4.ShipName," ",DCOUNT(Trim(INPUT.Name," ","T")," ")) for last name. For first name I used if check <>1 then FIELD(INPUT.Name," ",0,check1-1) else " " where check = DCOUNT(Trim(INPUT.Name," &qu...

hi kaps,
Thanks for your reply.
What you told works only John W smith. if there are more than 3 strings or less than 3 strings it doesnot. Instead of 3 in your expression i used the Dcount function to make it general.
thanks,
Ravi

hi ray, thank you very much for the reply. The thing i need is if we have a name like John W smith i have to get smith in lastname field and John W in first name field. iam getting smith in last name field and i have to get other than the last name every posssible string in the first name field. tha...

hi craig,
thanks for the hint. i am strict deadlines and you know if you have deadlines mind doesnot work . Any ways i will be careful from next time.
Thanks,
Ravi

Hi guys,
Any help would be really appreciated.

hi ArndW
Thanks for the reply. i got the last name but what about the first name which has every string other than the last name. it looks complicated to me. could you please help me out on that.
Thanks,
Ravi

hi guys,
I have to divide a name for example john w smith (input field name) into john w into first name and smith into last name. what are the functions that i can use.
any help would be appreciated,
thanks,
Ravi

craig and ray,
sorry for the late reply. i came into datastage from cobol so got used to it .
i havenot tried the field function. tomorrow i will surely try and let you know i could do it or not.
any ways,
thanks,
Ravi

HELLO GUYS,
I NEED HELP IN DIVIDING A FIELD CALLED NAME INTO FIRST NAME, LAST NAME . FIELD NAME HAS THE COMBINATION OF BOTH FIRST NAME AND LAST NAME.
ANY HELP WOULD BE APPRECIATED.
THANKS,
RAVI

CHULETT,
ITS WORKING.
THANKS A LOT,
RAVI

HI CHULETT,
The code i typed in is
OCONV(ICONV(DSLink4.TransDate,"DMDY[2,2,2]"), "DYMD[4,2,2]")
thanks,
Ravi

HELLO GUYS,
I NEED HELP IN CONVERTING A 6 CHAR MMDDYY FIELD TO 8 CHAR YYYYDDMM FIELD. I TRIED COVERTING INTO AN INTERNAL FORMAT AND TO THE YYYYDDMM FORMAT USING OCONV.BUT I AM GETTING SPACES IN BETWEEN THE YEAR DAY AND MONTH FIELD.
THANKS,
RAVI

hi,
i will have to access previous 5 days(depending on the date field output by the transformer) from the oracle database stage.i mean i want the design which can be used to do this involving an oracle database stage a transformer and any processing stage.
thankyou
rk

hi , i am developing a parallel job in which the design is as follows, transformer-------> lookup<------- oracle. the transformer outputs records in which i have a date field. i will have to look up into the oracle stage for the past 5 days worth of records depending on the date field output by the ...