DSXchange

SETFILE creates a VOC entry. OPENPATH does not. It is just more straight forward. Cleaner. A VOC entry allows you to run TCL commands against the hashed file like SELECT. I apologize for the brief delay in getting back with the results as I was pulled into different things over at my work. Anyways,...

SETFILE creates a VOC entry. OPENPATH does not. It is just more straight forward. Cleaner. A VOC entry allows you to run TCL commands against the hashed file like SELECT. Thanks Kim. I will try this approach and let you know how it goes. Unfortunately, I couldn't find "Sequences" under th...

TRANS() does not need a file pointer. It uses the real filename. If you have the hashed file open then just read it. You also do not need SETFILE if you use openpath. openpath pFilePath to pFilePointer else ...error logic here read Rec from pFilePointer else Rec = '' Field7 = Rec<7> Thanks for your...

Gurus, I have tried searching the forums for a relevant answer and couldn't find it. Most of the answers were very helpful, but I couldn't find a topic which deals with using a TRANS() function from within a loop. May be I missed it and would sure appreciate it if you can point me in the right direc...

2) What is the new features of Datastage 7? ( i.e From a developer Perspective) 2) What is the new features of Datastage 8? ( i.e From a developer Perspective) 3) What is the limitations of Datastage 7? ( i.e From a developer Perspective) 4) I want to know the below details of each version. a)Publi...

For example: Vendor A received 1 order, vendor B received 2 orders and vendor C received 5 orders A-->ord1 B-->ord1, ord2 C-->ord1, ord2, ord3, ord4, ord5 What is the best way to design such a table? Yamini Yamini, If you are trying to build this table in a non-multi valued database (as Pagadrai wa...

Even the OCI8 stage can interface with 10g using an 8i client. I don't think 10g was 'officially' supported until the OCI stage was included in 7.5.1a but that's not to say earlier versions were not compatible. Good to know...we have upgraded all our OCI8 stages to OCI9 using the utility IBM provid...

suryapkakani wrote:Is DataStage 7.5.0 Compatible with Oracle 10g release 2?

You need to have OCI9 stage for Oracle 10g.

ray.wurlod wrote:I would recommend removing this stage from the job design.

...and increasing the timeout settings for the Inter-process buffering.

Error Log:Abnormal termination of stage invEMEAInventorySnapshotStep2..sellable_xform detected sellable_xform is a transformer reading from a seq file having n record. Whenever the job is started it is aborting after reading n-1 records.I do not find anything unusual with the last record in the seq...

I am using the following variables: #$HRDMPassword# #$HRDMUser# #$HRDMPROD# The error message i am getting is: testedwdev..DB2_UDB_API_0: [IBM][CLI Driver] SQL30082N Attempt to establish connection failed with security reason "24" ("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=0...

DSbox61 wrote:Thanks guys. I convinced my DB on creating a temp table.

Did you try the Hashed file approach?

Thanks Craig. But I'm not allowed to create/drop/delete any table on production database using datastage. Is there any other work around? That's just a silly and stupid restriction. A 'connection' account can easily have its own 'schema' (whatever the DB2 equivalent is called) where work tables can...

Thanks Vivek. Let me put forward my understanding of your suggestion. You're saying, get the order_id into hash file and get everything from orders table (select * from orders) in db2 stage and then do look up on key columns(order_id) in the transformer stage. But, the problem here is if i do {sele...

Hi guys, I need to desing a job where i need to fetch some data from db2 database but only for selected values and those values would be stored in a file. Ex: select * from orders where orders_id={These values are in a file} with ur; I cannot use an IN clause coz there are some 30,000 orders for wh...