DSXchange

Okay. Thanks again

Could you please suggest a way to implement the above logic?

I am sorry, this is for a parallel job. My mistake, i didn't see the forum name. I don't know how to move it to the parallel forum.

Thanks if you could move it to the right forum.

Hi, I have the following requirement. There is a table containing some patterns like _ _ _ A B C A _ _ * * * A B C * * * Now, from the input stream, lets say we get an input field value as X Y Z A B C. We have to do pattern matching for this record using the following rules. 1) We check if the lengt...

Hello, I have written a Server batch job in datastage Enterprise Edition. It was running fine in the previous projects. Now I have created a new project on the same Datastage Server but now the Server job is aborting with the error: Attempting to Cleanup after ABORT raised in job JC_RUN_BATCH_R2_KCH...

No, I haven't used a sparse lookup. I have included the lookup condition in the SQL Query itself. I haven't used a lookup stage in Datastage.

Check out the query I have posted earlier.

Thanks for the reply. But I solved it another way. I inserted the values in table B by enclosing the column B values within the wildcard characters '%' . For example, instead of inserting 'MB', I inserted '%MB%' and then wrote the following SQL Query Select * from A, B where A.A like B.B I guess thi...

Hello, I have a requirement to implement the following logic. if column A from table A is like '%columnB%' from table B return target value from B Here A is the primary table, B is the reference / lookup table. This means that if column A from table A has the value 'A MB C' and column B from table B...

I have another problem now. The Column name is 'Customer #'.
I am reading it as

SELECT [Customer #] as Customer from XXX

in the ODBC Connector stage. But on running the job, the job aborts giving the error thet 'Execute failed don the Select statement'.

Any workaround for this>?

the source database is Microsoft Access.

Hi, I am trying to read data from a table which has column names defined as [Original Cost] on a source system. I am using an ODBC Connector Stage to write a select query like 'Select A."Original Cost" as Original_Cost from A". But I am getting an error for incorrect syntax. How can w...

Hi,

I have a stored procedure with no input and output parameters. I want to call it through a Datastage job. Which stage can be used?

Thanks. I used the SQL Enterprise stage and the CASE statement worked fine in it.

I mean that there are 4 conditional updates on the table. I can execute them on the database using the CASE statement, but ODBC connector does not accept the CASE synatx.

Hi, I need to execute 4 update SQLs on the same table in SQL Server database in a DS job. I cannot put the 4 Update SQLS together in one ODBC Connector stage. I want the SQLS to execute one after the other because if the SQLs are fired simulatneously, then a deadlock of table occurs. If I use 4 diff...

The maximum length in the database is defined as 2000