DSXchange

hello all sorry My Input Data in table only with 4 fields as below : ID, ParentID,ChildID,NAME 111, 100, 200,MDC 222, 200, 300, AAA---> 333, 300, 400,ABC 444, 400, 500,BCD Basically AAA is one special value and need to get always AAA id (it may differ for other set of records). Ex: If record BCD got...

Thanks Ray

Input Data:
111, 100, 200,MDC
222, 200, 300, AAA--->
333, 300, 400,ABC
444, 400, 500,BCD

Ex: record BCD got changed to DCB then i have to get the 222 from navigating 500 -> 400-> 300 -> 200 ->222

Output Data Should be:(only changed record)

444, 400, 500,DCB,222

Hi All Here is the crazy requirement, just let me know your inputs Input Data: 111, 100, 200,MDC 222, 200, 300, AAA---> 333, 300, 400,ABC 444, 400, 500,BCD Ex: record BCD got changed to DCB then i have to get the 222 from navigating 500 -> 400-> 300 -> 200 ->222 Note: No SQL, everything have to do i...

Hello

Thanks a ton for your info
I am using the Datastage ver 8.1 with fp1 but still my issue not resolved

I have good schema and name space but I tried with name space and without name space also but no luck

/ns0:Element1/ns1:Element2...


Thanks

Hi Greg

Did you creat a schema?-Yes
Did you read the documentation on using the object and how to configure it?
No idea how to config apart from the xpaths?

Did you define your repeating element? --Yes

Hello all The below example explains the issue XML Structure like as below ns0:Element1 ns1:Element2< Elements3,4,5> ns1;Element2<Elements3,4,5> Issues : 1)when we import in Datastage to XML input stage will get ??? for ns1 in the xpaths. 2) when we run it we wont get the values for Elements3,4,5 3)...

call the SP with parameters in the stage. Which stage you are going to use ?

Thanks to Arnd & Ray

ArndW wrote:Can you confirm if this is a version 7 or version 8 installation? Can you login to the director and administrator? ...

We are using 7.5.3.
Only I am not able to login any DS clients.
My colleagues are able to login.

When I try to login Datastage designer , gettting following error. But I can select the project from drop down list. And also I can login Unix server where datastage has installed. Error as below. Datastage Repository Interface Record EC784FEC-515E-4E28-874C-8C021FAECAE2-TCWDIWTS06P:5890350 ON FILE ...

HI Ray Thanks a lot for your resp But I used the call stmt also but it doesn't work for me getting the error msg saying that Invalid no of argumetns even i have given the exact number of parameters. BTW how to give in and out parameter in ODBC stage. when we call SP using the stored procedure option...

Hi Thanks a lot for your quick resp..

But the current ODBC stage doesn't have the option to call Stored Procedure. Its having only Read Method: Auto generated SQL,TABLE,user defined sql.

Please your thouths..

Thanks
SP

Hi DS Guys

I want to call the DB2 stored procedure in Ver 7.5x2 with input and output parameters.
The SP stage is there but its only for Oracle.So any other stages can use to call DB2 SP.

Adv thanks for your Information...

Thanks
SP

HI Kris thanks, But if my source is table then i need to call 1 script in that i need to connect db then i will get some record count as the output command along with the db connection information.It does't give the only number to output command. Basically i need to use the output of the script in ...

HI Kris thanks, But if my source is table then i need to call 1 script in that i need to connect db then i will get some record count as the output command along with the db connection information.It does't give the only number to output command. Hope its clear.. Thanks Hello Kris But just 1 questio...

Hello Kris Thanks a lot for your info But just 1 question when we execute the shell script from the Execute command stage we will get the connection information also in the command output how to remove that please...I want only count in the output command. If the source is a file you can use somethi...