DSXchange

ray.wurlod wrote:You can find it here. ...

Thank you for the information Ray. How ever when I am passing the value 023009 it still returns 0

any thoughts?

Hi , I am using below format to change a incoming date to required output . now when a date like 30-feb is coming which is invalid date below format is changing it to 2-march. OconV(ICONV(023008,DMDY[2,2,2],D-MDY[2,2,4] to 03-02-2008 Same is happening with 31sep changed to 1st october. ideally date ...

Hi , I have a teradata query Select Col1,Col2,Col3 From Tablename Where DayDt= CurrentDate-364 /** get a year back date from the current date**/ As current date will keep on changing .I replaced the above query in ODBC stage to provide the date at run time Select Col1,Col2,Col3 From Tablename Where ...

For this project this is the first time I am using drs stage. however for a another project we have used the drs stage. both project has server on different Unix box

Hi I am trying to insert data in sql server database using dynamic rdbms stage. I am getting the followoing error "Could not load drsodbc.so". I have some before and after sql statement to run using the DRS stage. However, when I have removed these sql statement and running the datastage j...

Can KeyMgtGetNextValue / KeyMgtGetNextValueConcurrent be set with a negative value.

My job requires to generate -ve number when ever the id is not present in source.

Do echo $A to see whether value of environment variable A is available in the shell. ... yes the environment variable is available in the shell the command is defining a variable B="AND Qualifier.Flag='Y'" .... echo "B=$B" ( retruning --> AND Qualifier.Flag='Y') .... Passing to ...

$ is for environment variables, sounds like you should just be passing in the string value itself. -param A='xxxxxxxx' ... This is also not working i tryied with single quotes as well as double quotes. I am using $ because I am defining this value -A and B above in the scripts. any other suggestions?

Sainath.Srinivasan wrote:-param name=value ...

Thanks Srini,
I am not able to understand your reply. Shall i try without using $ sign? also i just realized that i missed to put the =. I have modified my original message, if that is the difference than it is not working either.

I am getting the same error message.

Hi, My datastage job has a requirement of passing string as one of the parameter when running the job via script. Code Parameter A : "And value='Y' " parameter B : "And string <>'' " while calling the dsjob from another string the command I am giving 1. -param A= $A \ -param B =$...

Hi I am inserting teradata table using ODBC stage ( used b'se of performance reasons) while loading the NULL values it is being replace by junk and empty string. in the derivation I am doing following 1. the column data typeVarchar and the derivation on the insert transformer is @null -- in database...

Can you list the derivation of the target column tracing from its source. Something like Craig asked. ... A.Transformer 1: linkname.columnname varchar 50 B.transformer 2: linkname.columnname varchar 50 C.Transformer 3: to teraApi Trim(linkname.columnname,'B') varchar 100( for teraApi) D.Transformer...

What if you get the link from very first transformer without any derivation ? ... I have added a flat file in very first transformer and without any function on the derivation( linkname.colname) . In that flat file the data is coming intact i.e I can see the extraspace. But when the data reach to t...

Is this a server or PX job? You cite server in your post yet it is posted in the PX forum... Does the varchar field concerned have a length defined? This is a server job . Sorry for confusion. I am not sure how to change it now. There are two field which has same issue. the datatype and the length ...

It will go into the target intact unless you explicitly remove them. How are you certain that they are gone before you send them to Teradata? Have you added a logging link (or three) to check? ... This is not happening. I have added a flat file with the teraApi stage and passing the output in both ...