DSXchange

Hi, I want to use output of below query in transformer; I have created routine for the same which is not giving any output. $INCLUDE DSINCLUDE JOBCONTROL.H DB2Cmd1="db2cmd; db2 connect to target user user1 using pass; db2 SELECT 1 FROM schema.CUST_HDR fetch first 1 rows only; db2 connect reset;...

Thanks Klaus, It's working ...! I tried using "LOAD Immediate=YES" for this we need to set DB2 Bulk Load stage property for "FILE TYPE MODIFIER codepage=819" Using this I can directly run the job without invoking the load script. Thanks again for showing me correct path ... Regar...

Hi,
I'm trying to load Russian-Cyrillic data to Db2-UDB table using Db2 Fast/Bulk load; all the data is loaded except Cyrillic.

I tried same using Db2-UDB stage and I'm able to load Cyrillic data too. Does anybody know why this happening.

Thanks,
Narendra

ArndW, Thanks for replying; following is the complete error I'm getting. Address_IN..SEQ_Address.Lnk_Write_Address: nls_read_delimeter() - row 53, column STR_TYPE_CDE required column missing Address_IN..SEQ_Address.Lnk_Write_Address: nls_read_delimeter() - row 54, column SERIAL_NUM required column m...

Ray,
Thanks for the reply.
In DataStage Parallel edition Under Type Defaults-->Genral-->Byte Order of Sequential File stage option is available using which I can assign Multiple-byte data types like little-endian and big-endian do we have something similar in Server edition.

Regards,
Narendra

Hi All,
Is there any data type or conversion available in DataStage to use datatype like Little endian and Big endian.
This datatypes are available in Ab-intito plz let me know if we have this kind Datatype available in DataStage.

Thanks in Advance,
Narendra.

Hi All, Does anybody knows how to create Fixed width Binary file. For eg.Input Column has Datatype Long Int which is of size 4 bytes and the output has to be stored using 4 Bytes memory space only.Similar to Fwrite() function in C. Similary a short int should be stored in 2 Bytes Memory space and a ...

In &PH& folder.Following file got produced when we ran the job.
DSD.RUN_70287_13708

and content of this file are as below
Project not found

Can you please tell me what could be the reason.

Thanks,
Narendra

Andw, This is a fresh installation. We created one sample job.That I'm able to comiple thru normal user as well as admin.But that job is not runnig. We tried to develop and run Server as well as PX jobs none of the job is running. &PH& is empty as of now. Thanks in advance. Regards, Narendra

Hi,
For this You can not create a hash file as a driving file to bring all records(i.e.Outer join).You need to do this in 2 pass,first create a hash file from sequential file and then this newly created hash file can be used as a driving file.

Regards,
Narendra

Hi everybody,

Can anybody help knowing PX trainer in India.


Regards,
Narendra

Hi Sasi, I'm also facing same problem i.e.(40503)-A call to an OLE server failed. I think this is due to lots of processes running on your pc and Datastage wont find free space. Another reason could be netwrok connectivity. Sasi if you find the exact solution for the same plese let me know. Regards,...

Hi everybody,

We have 2 hash files.And 1 Oracle Stage.

I want to pass Hash1 Arr_Id and Hash2 Bill_date to Oracle Oci stage as a dynamic parameter.

So query will be like below

Select sum(Tram_amt)
from t1
where arr_id=&Hash1_Arr_id
and dt=&Hash2_Bill_date

Thanks & Regards,
Narendra

Hi Everybody,
can anybody tell me why I'm getting this error ?

DataStage Job 62 Phantom 27651
Program "JOB.656555515.DT.1362481236.TRANS1": Line 187, Nonnumeric data when numeric required. Zero used.


Thanks in Advance,
Narendra

[quote="jayawant_hsbc"]hi my problem is that, we r reading frm a flat file and the digits are seperated by commas and we need to remove the commas ex 1,500.00 is to be formatted to 1500.00. tell me the solution using enterprise edition as well as server edition thankyou[/quote] Try using O...