DSXchange

i have a column xxxx it is of format yyyy/mm/dd DATE datatype(8) i have to see whether it is a valid format or not and if it is valid i have to load to target TIMESTAMP(30)? how can i see if it is valid or not

I have a date column in my source like 1886/09/06{datatype-date(8)} i have to check it for some Rules and populate to target{timestamp} when i am populating i am getting error cannot convert date to timestamp value is taken as null. how to convert a date to timestamp format


thank u

i have a column xxxx it is of format yyyy/mm/dd i have to see whether it is a valid format or not and if it is valid i have to load to target? how can i see if it is valid or not

i am using \\ and "" every thing is working fine when i am testing it, but when i am useing in my job it is giving the following error Transformer_1: At row 3, link "ToLoadSCTY_comm", while processing column "STRIKE_PRC" Value treated as NULL Attempt to convert String v...

how can i represent blank values in datastage? i want to populate blank for some rules, i have tried "" and " " but the error is comming as attemted to "" convert to string treated as null. i have also tried @NULL.STR but it is not working how can i represent blanks tha...

I am using server edition,I have to populate in my target enddate column as "2045/11/08" i enddate column datatype is timestamp i am tried aboveformat and "2045/11/08 00:01:00" but it is showing only year "2045/00/00" how can i populate the whole thing....



thank u

Hi 1)Iam ding server jobs in one of my transformations i have to populate end date as processind date-1 i have used Oconv(Date()-1,"D/YMD[4,2,2]") but it is not working how can i do it my enddate is timestamp and we are using sequeal server..... 2) i have to populate this date as startdate...

i am using a sequential file > Transformer > MS OLEDB i am using 8 hashed files for the lookups but my in job only one hashed file is reading source data remaing all hashed files are showing 0 rows. But we can see matching columns in source file and hashed file . i have tried using trim() function,b...

it also working

Hi Every body iam very new to Datastage i have one issue i have input fixed width flate and eight hashed lookups so, while looking up this input file with the hashed file it is not working input file data length char(40) is there but in hashed file key column Varchar(8) is there but if change input ...

Hi
Every body iam very new to Datastage i have one issue

i have to Fecth record within Acccont
MID(Account,5,5)

thanks inadvance

Thanks
right function is working for .IR and .Un
count function is working for 'EXCH'

all i have one issue on routine for control table/hash file it has read from A routine that will read a control table/hash file and get a column value. Use that value as datastage job name and 'Run' that job, automatically. i dont know how to write basic code for that plz some one help me this isuue...

hi
all
i have one issue on

routine for control table/hash file it has read from

A routine that will read a control table/hash file and get a column value. Use that value as datastage job name and 'Run' that job, automatically.

thanks in advance

hi all iam new to datastage, i have one issue check whether the string in between two strings or not i have two strings i,e alpha numaric values the string has to check string in between two strings i have strings like this from string a/c no 225-2112-1A to string a/c no V-2234-TRDC so,i have to che...