DSXchange

Hi gurus,
even if i include the substring my expression gets invalid.plz help me in syntax , how to deal with this type of data.
1980-12-17 00:00:00.
plz help me in syntax how to use my 0conv and Iconv transformations.
and get o/p as 17/12/1980 00:00:00

cheers;
vijaykumar

Hi gurus, thanks very much, i could valid my expression. but what if the i/p is in this format 1982-07-22 00:00:00 1981-09-28 00:00:00 iam following same derivation which you people helped me Oconv(Iconv(DSLink3.HIREDATE,"D-DMY[,A,]"),"D/YMD[A,]") when i validate and run, it does...

Hi Gurus, sorry the information which i gave is incomplete. i got a i/p column in my source. hiredate 21-may-1981 27-june-1987 20-march-1989 i want the o/p column hiredate to be displayed as hiredate 1981/may/21 1987/june/27 1989/march/20 for this, i used ICONV ,OCONV datetransformations for i/p col...

Hi, actually the HIREDATE column dervation turned into red, that means my column derivation is incorrect. plz help me in derivation.plz help me in synatax of that column Hiredate- to which i applied date transformation functions. this is the way i have defined. Oconv( Iconv("DSLink3.HIREDATE&qu...

hi gurus, i got a column in my source as HIREDATE which has values as 08-SEP-81 23-MAY -87.i want to have the values in this column as 81/SEP/08 ,87/MAY/23. iam using date transformation functions such as ICONV AND OCONV. Oconv( Iconv("DSLink3.HIREDATE","%DYMD",DDMY[,2]) DSLink3....

hi,
thanks very much , i was specifying the same table name in the source and target.

cheers;
vijay

hi Gurus, my source is oracle, my target is oracle. iam using ODBC STAGE as source and ODBC STAGE AS TARGET. i can compile and run, but after running the jobs , i can see that the data is not loaded in the target.iam getting warnings, whenever i run the job, i went to view the warnings from the logf...

hi, iam running 2 jobs sequentially, my design is jobactivity1----->jobactivity2----->sequencer-----> i want to run my jobs every friday, i defined a jobparameter went to edit tab and defined a parameter. jobactivity2 that means my job2 has many joblevelparameters defined. where should i include a p...

Hi gurus,
iam getting errors like.
DYNAMICRDBMS_0:DSLINK3:DSLINK3:DSPOPENGCI
TRANSFORMER[DYNAMIC RDBMS_0 DSLINK3:DSP OPEN ERROR 100]
iam able to compile, but its not validating.
plz help me.
cheers;
vijay

Hi gurus, when i see the director-log, iam getting lot of warnings. warnings such as DRS6:TRANSFORMER_2:CUSTOMERID=COMPANYNAME=CONTACTNAME=CONTACTTITLE=ADDRESS=CITY=REGION=POSTALCODE=ADRESS=NULL here customer id,company name all are the columns in my database, iam extracting data from MSSQL SERVER. ...

Hi Gurus; iam using DRS STAGE as source stage as well as target stage. In the target DRS STAGE, iam defining the properties of target stage as create table action-do not create database table- since i don't have priviledges. update action-insert rows without clearing. Array size-1 Transcation size-0...

Hi Gurus,

Thanks very much, yaa iam able to run the job , but inorder to view data i need to replace the default value $projdef with mssql server.

thanks a lot

cheers;
vijay

Hi gurus, i have given incomplete information. the problem is I declared a project level parameter. RDBMS NAME i have given value- MSSQL SERVER. At joblevel i selected user-defined param and i browse for the parameter which was declared at project level. when keep the value of my parameter to MSSQL ...

Hi gurus, THANKS VERY MUCH. i could solve that problem. i specified the value of RDBMS- MSSQL SERVER again, i changed it at joblevel- changed value to default value or env value $PROJDEF. iam getting error DS BROWSER..... DYNAMIC_RDBMS_0:UNKNOWN CLINET LIBRARY-$PROJDEF. I understand from this error ...

Hi Gurus, Thanks very much i could declare a jobparameter in the required fashion. I got another problem , when i work out with DRS stage and browse for jobparameter , it says NO PARAMETER FOR #RDBMS# EXISTS, due to want to declare such parameter.when i click yes and want to view data it prompts to ...