DSXchange

hi, my design is odbc---->transformer---->odbc my transformer has a logic inside.i want to reuse the transformer stage in other jobs also, i went to edit and designed a shared container. as per rules container is available in manager, but how can i use that server shared container in my designer whi...

Hi gurus,
i want to merge 2 ODBC databases, but what i try to join two odbc stages, iam getting a message that merge doesn't support i/p links.
what i learned is merge works just like a join, but now why am i getting this type of peculiar message, plz help me to analyze the property.

cheers;
vijay

hi Gurus,
thanks very much.
i could resolve the problem, when i give DSLINK5.DEPTNO=$DEPTNO.
it works fine.
iam marking the topic as resolved.

cheers;
vijay

hi Gurus, i want to give deptno as parameter. name prompt type value deptno enter the deptno string 20 the main problem is why it doesn't have default types other than string and encrypted. as i want to specify constraint in transformer stage. in the transformer stage--- i want to define constraints...

Hi gurus,
thanks very much.
when i connect to sequential file, i can view the data.
dont know whats wrong with ODBC.particularly with the length.
Once again thanks very much.

cheers;
vijay

hi gurus, odbc--->transformer---->odbc---->rowsplitter--->2 odbcs i wanted to analyze the property of rowsplitter. i have joined 2 tables in the source stage, and stored in ODBC stage. iam storing the join of 2 tables in ODBC for other purposes. now can i use rowsplitter to get back my source tables...

hi, thanks very much. i used this transformation, i could valid my transformation and run without errors, but went to director to view the warning message. Oconv(Iconv(Field(DSLink3.HIREDATE," ",1,1),"D-YMD"),"D/DMY[2,2,4]") iam getting this warning. drs18datetransf..Tr...

hi gurus,
thanks very much.

when i use downcase(linkname.columnname)- iam getting the actual result.

thanks very much.

cheers;
vijay

hi, i wanted to change the values in column ename into lower case letters. i have a column ENAME VIJAY VII VICT i want to change all the values in my column ENAME into lower case. for this in the transformer stage i used downcase("%ENAME%") iam getting the o/p data in the form ENAME %ENAME...

Hi gurus,
THANKS VERY MUCH.

i changed my update action to- clear the table and then insert rows.
iam not getting any error.

cheers;
vijay

hi gurus, iam doing join of 2 tables in my source stage. its compiling and running without any errors, but its not loading in the target database. plz help me, iam getting warning. [DataStage][SQL Client][ODBC][Oracle][ODBC][Ora]ORA-00001: unique constraint (SCOTT.SYS_C001342) violated. plz help me ...

hi, my design is DRS---->TRANSFORMER----->DRS iam getting error: TNS COULD NOT RESOLVE SERVICE NAME. when i use ODBC---->TRANSFORMER--->ODBC. its working fine. why is that when i use DRS STAGE iam getting error, plz help me. my DSN is correct,since iam able to extract data using ODBC, why not with D...

Hi gurus, iam using odbc stage as source. odbc--->transformer---->odbc. i have created parameters for odbc connection, user name and password in administrator. i called them through designer and used in the source stage, i can view the data from source stage.i can compile the job without errors but ...

HI, thanks for helping me but iam getting syntax error Oconv(Iconc((Field(DSLINK3.HIREDATE, " ", 1, 1)"D-YMD[4,2,2]"),"D/DMY[2,2,4]") :" ": (Field(DSLINK3.HIREDATE, " ", 2, 1)) DSLINK3 is the i/p link. Hiredate is the i/p column. 1980-12-17 00:00:00 ...

hi, when i use this synatx and valid my expression, Oconv(Iconv(Field(InLink.TheTimestamp, " ", 1, 1), "DYMD"), "D/DMY[4,2,2]") : " " : Field(InLink.TheTimestamp, " ", 2, 1) iam getting error variable"inlink.timestamp" not defined. when i a...