DSXchange

Hi, Can any body help me here . I have the data in the table like below. Key1 Key2 code(Key3) status A 1 X IN A 1 Y IN A 1 Z OUT B 2 M IN B 2 N IN B 2 O OUT How can I get the results like below. col1 col2 col3(all codes seperated by comma) col4(codes where status = IN) A 1 X,Y,Z X,Y B 2 M,N,O M,N wh...

oops sorry its



sh b.sh 2>&1 >> /work/log/a_log.txt
sh b.sh

That should do it.

Forboy

Basically you issue two commands in a.sh

sh b.sh 2>&1 >> /work/log/a_log.txt
sh b.sh 2

That should do it.

Forboy

Server Version 7.5.2 is available and we have been using it for the last two months.

Yes,

Columns must be checked for isNull function before checking to another value. I did many complex calculations in the transformer and experienced the same thing.

One more thing null values can not be assigned to the stage variables in PX.

forboy

compile using the following command


/usr/vacpp/bin/xlC_r -+ -O -g -c{C prog Name} -o{object file name}


This is only for IBM AIX.

Cant you lookup on the table that is being updated. If you are using a DB2 table then you cannot read from the table at the time of an update because a table level lock occurs. You will have to run the jobs sequentially in that case. I guess lookup gets all the records into memory when the job is s...

How can I do a dynamic lookup.

I have a situation where Iam looking up a table and and table is constantly getting updated by some other job. I need these updated values reflected in the lookup as both the job runs at same time.


Thank You
Forboy

Hi, Iam Using stored procedure stage in Datastage 7.5.1. I want to call Teradata stored procedure and procedure type is transform. Can I call Teradata stored procedure because in the Database vendor it displays -- Oracle, DB2 and Sybase only. I tried using these vendors I got the follwoing error. St...

thanks roy,

Iam just wondering can we assign @true for a decimal, because my calculations comes like this
a * b =c c is a stage varible (decimal)

if a or b are null then it should be set to null, I can't use c in regular varible because Iam using c again in many calculations.

hi,

Iam using parallel trasnformer in which Iam using 20 stage variables for complex calculations,If one of the input variable coming is null, then I got to set entire thing to null, but px stage varible doen't allow null values assigning to it, How can I do it.

Hi, I have Strange question, When I try to compile one of my job, I get an error saying that "cannot give exclusive permissions......". Strange thing is i am able to export the same job from the DS Manager. I checked on unix , closing all the data stage processes for DSSLAVE_API.I see no p...

Hi, I new to DS, anybody help me with solution for this, I have source coming from text file and DB2 table. target is DB2 table. I have straight move from text file, but from DB2 table I need to get only one column which is date, I need to get latest date from it, these two sources( text file and DB...