DSXchange

Thanks Craig.I will try with combination of Index and substring or introduce ereplace first and then apply field.

Hi , Can't we pass a string like 'abc' as delimiter for field function in Server job? I was using the same function in parallel job with a string as delimiter.The result was as expected.I got a situation to change that job to server job to use UserStatus feature.The output is different from the one ...

Thanks a lot!! These points give me the exact cases to present.

Hi All, We were asked to present the Pros and Cons for using Oracle as repository against DB2 since there is no DB2 admin available in the organisation. Is there a document or points somewhere to get the Pros and Cons of using Oracle for Xmeta?? Please provide hints if there is no specific document ...

Please suggest a way to create a seq. file in the target with the name coming from input column.
I know the reverse is possible when we read the Seq.File ,the filename column can be selected.

The "Commit" has been written in the procedure and it is working fine now with Transaction Isolation as Read-Only

Hi All, We have a requirement to execute an oracle stored procedure which has two input and two output parameters.I am using stored procedure stage with the procedure type "Transform" Transaction Size =0,Checking the option Execute procedure for each row,Transaction ISO= Read Committed. I ...

To get only alphabetic values use this Convert(Convert('ABCD..Z','',Upcase(Col)),'',Col) and to get numeric values only replace the alphabets with numbers..

After the above process pass the data to a column import stage and split the column's data to multiple columns or use a transformer field function whichever is effective with your volume of data..

Hi The issue is resolved. It is an Oracle SP.I had to provide input link to a Transform type to pass values but I assumed that we can pass the values from the Parameter Marker/literal field.It is now working fine.I was a bit quick in posting the topic and simultaneously tried a different way from wh...

Hi All, We have to execute a stored procedure which has 4 arguments out of which 2 are inputs and 2 are outputs. for e.g USP_GEN_SEQ_NO(param1 IN ,param2 IN,param3 OUT,param4 OUT) I made the Stored Proc as a Transform and imported the parameters and mapped them to the corresponding columns.For the t...

I have entered the database name instead of ODBC DSN and it got connected.

I doubt you enter either the actual SID or ServiceName there, have you tried using the name of the TNS entry there? It would then specify the actual connection information to use. ... The connection issue is resolved and we are able to connect to database and import metadata of the stored procedure...

Hi Norton,
We connect to that DB referring to Service Name but the ODBC Wire Protocol connection does not have the field to enter ServiceName in the list.Hence the SID.Please let me know if there is a way to make an ODBC connection using Oracle wire protocol entries for ServiceName