DSXchange

The server Sequential File stage will read a CSV file like your example. Set 'Outputs-Format-Missing columns action' to 'Map empty string', and 'Outputs-Columns-Incomplete Column' to 'Replace'. If you need your CSV file to be an input to a parallel job, consider writing a pre-processor server job th...

Can you try this, and see if it helps?
On the Syntax tab of your stored procedure stage
a) Uncheck Generate prodecure call
b) Edit the Procedure call syntax so it looks like this

We run DataStage 8.7 on Windows Server 2008 with jobs scheduled via the Windows Task Scheduler. From time to time, our XMETA database goes down. Our experience is, that while the database is unavailable: - We can't use Director, Designer or Administrator. - Scheduled jobs start at their scheduled ti...

Also try checking the setting of your TMP and TEMP environment variables, in the context of the user that is running the DataStage job. This is easiest done by looking at the log entry headed 'Environment variable settings'. The user that is running the ODBC job needs to be able to create subfolders...

Evan, did you ever find a solution to this problem? Thanks

Try this - in Designer:

• Open quick find
  Enter the job name, click Find
  Click the '1 match' link

Have a look at this viewtopic.php?t=119030 and see if it is relevant to your situation (it may not be).

Have a look at the Windows schtasks command. I've found these options the most useful:
schtasks /Query /V /FO csv

I agree that the string that we want to search in should be the first argument to Index, and the string that we are searching for should be the second. But don't we want to look for '|':lnk_xfmr_target.CLASS:'|' in '|ARC|PPD|CCD|CTX|COR|DNE|' and doesn't that make the original example correct? Happy...

Unable to initialize communication channel We have Windows servers, and whenever I've seen this error it's always been about the number of OS processes DataStage is running. Reducing the number of processes eliminates the error, in my experience. Reduce the number of processes by amending sequences...

In the database, create a view based on your query. Then import the table definition of the view.

Hi Also consider that it may not matter that the business key is null. I would think that in the end you'd want two statements like this: UPDATE table SET ename = 'kirankumar', salary = 1000 WHERE sno = 1; INSERT INTO table (sno, eno, ename, salary) VALUES (3, 567, 'somu', 19990); and your output is...

Have a look at some code that I added here viewtopic.php?t=138713. As I said over there, it's not particularly elegant, but it works for me.

Here's a piece of quick and nasty VB code that I have used to obtain information on dataset usage. It reads a V8.0.1 dsx export (without executables), and reports on all the datasets it finds. Hope you can turn it into something that's useful to you. Public Function DataSetUsage() Dim ExportLine As ...

devesh_ssingh wrote: above approch is giving me error lin agg stage as it map calculation max_DT as double datatype and hence type conversion errore

Would setting the property Preserve Type = True on the Column for Calculation solve this part of the problem?