DSXchange

Hi ppl, I have job which runs on production box. I am creating a temporary table in DB2 for that particular session with the following query: DECLARE GLOBAL TEMPORARY TABLE session.XTEMPPRICING1 ( PRODUCTID VARCHAR(16) not null, NEWPRICETYPE CHAR(1) not null, NEWPRICE DECIMAL(20,5), PRECEDENCE INTEG...

Thanks Ray. That was really helpful. I was able to see these settings thru Datastage Administrator under Tracings Tab.

Hi folks,

I am getting this warning whenever i open the director: WARNING: Repository Interface Tracing is switched ON.

Can you please tell me what this warning means.

Thnxxxxxx

I'm able to fetch at more than 1000 records/second from DB2 and the same while loading the hash file. More than 1000 records/second is fine with me. But, if i try to compile another job while the hash file is getting loaded, then it takes a long time. Any other activities such as taking a look at lo...

...i'm getting it wrong when i submit the post.......i better put it in words....i'm doing a look up with hash file in transformer stage and not in DB2...........

sorry folks the design is wrong

here is the corrected one.

DB2===>Tx===>DB2
^
||
||
DB2==>Hash File

Hi ppl, I am using hash file in my jobs but i got a very poor performance. I am running jobs that would work for initial as well as delta load. DB2===>Tx==>DB2 ^ || || DB2==>Hash FIle I am fetching about 600K records from Mainframe and doing a check if it is existing in my DB2(based on key columns)....

Hi folks,

Just wanted to know if ther could be any offer for premium membership.....for $50/year instead of $100/year....i missed on the earlier offer.......can you please bring the offer back....

thnx...

hi ppl, thnx for your answers....but i need more specific than using a REJECTED option in constraint coz the condition i'm using in stage variable is like this: If DSLink3.SRV_ARE_RST_MDL_ID=46162 Then DSLink3.VEND_PACK_ID Else (If currentUPC <> lastUPC Then DSLink3.VEND_PACK_ID Else ___ ) The rows ...

Hi folks, i have a job where in transformer stage i'm checking for a few conditions thru stage variables and If then Else statements. At one point after checking many conditions for one particular column...i have to reject rows tht do not meet the conditions. how can i reject rows thru stage variabl...

yes sam, even i implemented the same u mentioned.....it really is the perfect solution......thnx 2 all gurus...and thnx to jim. :D

But we cannot achieve vertical pivot through pivot stage in server edition rifght!

Hi ppl, I have a job where i have 3 records coming from DB2(1) C1|A1 C1|A2 C2|B1 and 2 records coming from DB2(2) C1|X1 C2|X2 In the output file i want C1|A1A2|X1 C2|B1|X2 DB2(1)==>Transformer==>Flat File ^ || || DB2(2) thnxxx...

Thnx for the help guyz....and craig, i am on server edition...i was just trying decimaltostring function to see if it can help me in any way... i resolved the issue by converting it to char as part of the sql query, tht i used in db2 stage and then trimmed the trainling dot(.) in transformer stage. ...

hi folks,

i have a column with datatype decimal(9,0) from mainframe and i want to convert it to varchar and insert into another database.

Basically, i want to do a decimal to varchar conversion. i tried using DecimalToString but i could not get the syntax correct.

can u pls help me....thnx.