Search found 46 matches
- Mon Jan 22, 2018 4:32 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to read comma delimited files with missing column values
- Replies: 8
- Views: 5383
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...
- Thu Mar 03, 2016 6:51 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error while executing Sql Server stored procedure
- Replies: 8
- Views: 6157
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
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
Code: Select all
{ ? = CALL UP_IN_AMBIT_PRICE }
- Mon Feb 22, 2016 6:51 pm
- Forum: General
- Topic: XMETA database is down. shall I run the jobs?
- Replies: 3
- Views: 3832
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...
- Tue Nov 25, 2014 12:08 am
- Forum: General
- Topic: MS Access connection
- Replies: 6
- Views: 4887
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...
- Sun Jun 02, 2013 9:00 pm
- Forum: General
- Topic: ODBC errors on scheduled job only
- Replies: 3
- Views: 3696
- Tue Feb 12, 2013 4:10 pm
- Forum: General
- Topic: How to find the username who has last modified the job
- Replies: 4
- Views: 3239
- Mon Feb 11, 2013 6:12 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: the call to sqlldr failed the return code = 1
- Replies: 4
- Views: 4053
Have a look at this viewtopic.php?t=119030 and see if it is relevant to your situation (it may not be).
- Thu Jan 03, 2013 3:59 pm
- Forum: General
- Topic: Windows Scheduler and datastage tasks
- Replies: 3
- Views: 2705
- Sun Dec 30, 2012 5:51 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: NOT IN in datastage
- Replies: 16
- Views: 9175
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...
- Tue Nov 29, 2011 4:10 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Player terminated unexpectedly.Unable to initialize communic
- Replies: 9
- Views: 32342
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...
- Wed Nov 02, 2011 5:05 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Importing columns
- Replies: 2
- Views: 2169
- Sun Aug 07, 2011 6:10 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: scd with oracle tables -- problem
- Replies: 5
- Views: 3155
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...
- Mon May 02, 2011 6:22 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Find Datasets used in Project
- Replies: 2
- Views: 5996
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.
- Thu Feb 17, 2011 7:44 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to find the group of jobs using the same Dataset
- Replies: 4
- Views: 5162
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 ...
- Thu Nov 04, 2010 8:09 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: logic required
- Replies: 6
- Views: 4418
Re: logic required
Would setting the property Preserve Type = True on the Column for Calculation solve this part of the problem?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