DSXchange

trying it,

I have initialized the constant string as a job parameter.

my concern is , can we pass an input parameter as a job parameter ?

Hi ,

is it possible to append a string at the beginning of a column in the modify stage ?

if it is used as a job parameter ?

e.g. i/p is a char column & I want to append a string 'AA' to every column.

Thanks in advance .

sumoka

Thanks!

Actually I touched datastage designer after 2 years . memory became a bit rusty. Thanks a lot!

Hi ,

I am using a column generator to create a new column , datastage populates random data to it.

I want to assign a constant value to it, is it possible ?

P.S. I don't want to use a transformer

thanks in advance.

sumoka.

Thanks Ray ,

will assume the representation mentioned by you and work on it.

will share the solution once I get it.

Thanks again.

Hi ,

The i/p is a decimal (5,0) 09134.

and I don't know the standard date representation.

I understand my limitations here .. if anybody can give a solid hint.. which after a little working on can yield a result it wil be great.

Hi ,

The i/p is a decimal (5,0) 09134.

and I don't know the standard date representation.

I understand my limitations here .. if anybody can give a solid hint.. which after a little working on can yield a result it wil be great.

The i/p is a decimal (5,0) 09134.

I tried teh following code :

DateFromJulianDay(AsInteger(Field(DecimalToString(<ColumnName>,"fix_zero") ,".",1) ))

it gives teh o/p in '*' i.e. junk

Hi ,

if any body has a solution please help.

the desired format is YYYY-MM-DD

or any other format will do .

Hi Andrw,

I have actually done it :D

thanks a lot!

Hello all , I have two CFF files which I am using reference & stream in lookup. But , it fails due to no matching records, I need to modify one of the files for testing to have some matching records. I can use a transformer to do that. The concern is how to make the changes effective in one of t...

Hi ,

I have been asked to tune a datastage job which is running for very long due to congestion in netezza box.

one solution is load it to a dataset . I have also heard about external tables in netezza will that be helpful in solving this problem ?

Please help.

sumoka