DSXchange

Hi Everyone, I am going through the Datastage PX e-training. I have installed PX on my PC ( the OS is Windows 2000 professional), it seems that I can only build and compile PX jobs, but not running them. My questions is, does PX run on windows, or is there any extra work I need to do to make PX runa...

Hi everyone,

My database password changes once a month, is there any way I can create a global stage variable so that all jobs in the project can use it as the database password?

Hi everybody,

I want to have a special hash lookup, in stead of matching the key, I will math the key within a range, that is, if the input file's key equals the key in the lookup hasfile, or if the input files' key - a key in the lookup file <3, then match.

How can I do it?

Hi Kim, I wrote a script like this, but the problem is, it ONLY process the fist variable, because there is no waiting, that is, the dsjob will be called for n times almost at the same, and only the first one will work. is there any wait statement I can use? You could do it in a shell script as well...

Great! This information is extremely helpful. Thank you! DataStage access security is based around operating system groups, not user IDs. You will need to create separate groups, let's say dsproj1 and dsproj2, and put user1 in one and user2 in the other. In the Administrator client, configure the se...

Hi, I am going to set up 2 projects for 2 seperated teams on the same box using Datastage Administrator. here is the requirement: I need to set up 2 projects, say project1 and project2 for user1 and user2, so that user1 can ONLY access project1 and user2 can only access project2. I need to set it up...

Hi everyone,

I need to conver a hex number to an integer. Is there any built-in function in Datastage that does it? or I have to write my own funtion.

chulett wrote:You might want to consider using an OCI stage, or better yet (if on 7.5) the Stored Procedure stage.

I tried OCI stage, and it works. But is there any disadvantage if I use OCI stage instead of odbc stage?

Hi every, I tried to call a stored procedure using an odbc stage. here is the error message, does anyone know what's going on? Thanks. |LdUserDetail_0812.ODBC_50: DSD.BCIConnect connecting to userDB, call to SQLConnect failed. SQLSTATE=IM002, DBMS.CODE=0 [DataStage][SQL Client][ODBC][DataDirect][ODB...

Hello everyone, I am a fresh man on PX. I need to rewrite a Datastage job in PX. It is a simple job, but the volume is hugh. The source only has 3 colums, but 300 million rows. I only have 2 simple lookups. But one lookup hash file has 10 million records. When I run this job in Datastage, the speed ...

Hi everyone,

I have a question about lookup. If the lookup item is not unique, will it return an error, or it is going to return the first value found.

Hi everyone,

I need to convert a varchar into a numeric.
the varchar looks like this +xxxxx.xx , where x represents anumber.
for example, +00000.00, +00106.98, +00020.55

can anyone give me some ideas?

hi everyone,

I have this trouble when I tried to schedule a daily job. Here is the error message:

Error adding to schedule: crontab: you are not authorized to use cron. Sorry.

what's going wrong?

Hi everyone, I extract a number from a csv file and load it into oracle. The oracle type is number, and I got this error message. Transformer: ORA-01722: invalid number I looked this up, it indicates that I am inserting something that is not a number to a numer field. but the data i get from csv are...

Hello everyone,

I am going to build a time dimention table that covers all dates from 1990 to 2030. The table has a time key, year, month, and day. how do I do it?