DSXchange

I removed the whitespaces by using stripwhitespace function and then applied ALPHA..But the output of ALPHA is 0 instaed of 1. why?

"STREAM GSDW nsc D"

I used the above string only in my file.

All, I have to check whether a string contains only alpha numeric characters. I used ALPHA() Function, but it is not giving the expected result set. Input file has "STREAM GSDW NSC D" - Expected Result Set is OK "STREAM GSDW1 NSC D" - Expected Result Set is FAILED. As It contains...

Any Inputs ?

Datastage Settings: Project default (ISO_8859-1:1987) Unix Settings: $ locale LANG=en_US.UTF-8 LC_CTYPE="en_US.UTF-8" LC_NUMERIC="en_US.UTF-8" LC_TIME="en_US.UTF-8" LC_COLLATE="en_US.UTF-8" LC_MONETARY="en_US.UTF-8" LC_MESSAGES="en_US.UTF-8"...

All,

Does datastage have any default userid and password to login into the console?

Inputs are welcome!

Thanks
Karthik M

11.3 only.

All,

I would like to install datastage 9.1 in my laptop. is it available for free download?

All,

is it possible to upgrade Datastage 7.5 version to Datastage 11.1 directly?

I heard we can't move like that. First we have to migrate the jobs to 8x version and then 8X job needs to be migrated to 11x.

Inputs are welcome!

All,

What will happen if the file (which is currently in use by datastage) got updated or deleted ?

Hi All,

What will happen if i choose round robin partition type for lookup stage?

i have tried it and verified the score. i can see "entire" only instead of "round robin". why?

All, I am back to datastage after some short break. I am in the process of refreshing my datastage knowledge. I would like to know what is tthe difference between uvconfig file & DSParam file ? ORLogging/DSLogging information is available in which file ? AUTHORIZATION variable is available in uv...

system variable? which one?

All,

We are using Datastage 8.5 version. I have a requirement to generate the sequence number based on some code.
This can be done with the help of 2 or 3 stage variables. But i just wanted to know is this can be done with the use of "TRANSFORMER LOOP".

I am usign ODBC Connector.

I have seen some info on the below URL.

viewtopic.php?p=359928

That it already set to Project default ( UTF-8 ) for both 'NCHAR/NVARCHAR2' and 'Other types'

How to know UTF-8 are mapped to NCHAR/NVARCHAR ?

All,

Does datastage strong in ETL or ELT ?
which one will be good in future?