Search found 20 matches
- Tue Nov 04, 2008 11:16 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Credentials issue with dsexport
- Replies: 0
- Views: 1378
Credentials issue with dsexport
Hi, I'm trying to run the folloeing command from windows client machine to export a dsx from the unix server:- C:\IBM\InformationServer\Clients\Classic\DsExport.exe /H=xxxxxxx:9080 /U=xxxxx /P=xxxxxx /JOB=job1 xxxxx_DEV job1.dsx (Note: for purpose of illustration I've substituted the correct values ...
- Fri Aug 01, 2008 9:21 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to process a sequential file containing quotes.
- Replies: 15
- Views: 50986
- Fri Aug 01, 2008 4:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to process a sequential file containing quotes.
- Replies: 15
- Views: 50986
Hi, Also just to add to my previous comments, if the data contains quotes, then the csv file will be saved with double double quotes. Has shown is my first post. Correct me if I'm wrong, but using crsi suggestions, then double double quotes would be loaded, instead of the original a single double qu...
- Fri Aug 01, 2008 4:18 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to process a sequential file containing quotes.
- Replies: 15
- Views: 50986
- Thu Jul 31, 2008 10:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to process a sequential file containing quotes.
- Replies: 15
- Views: 50986
How to process a sequential file containing quotes.
I need to load a comma separated sequential file where each column is wrapped in a pair of quotes e.g. "Field 1", "Field 2", "Field 3" But in some columns there are quotes within the data, e.g. "Field 1", "New ""Field" 2"", "...
- Wed Jul 30, 2008 2:20 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Hash File Calculator (HFC) wanted
- Replies: 3
- Views: 2793
- Tue Jul 29, 2008 10:00 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Hash File Calculator (HFC) wanted
- Replies: 3
- Views: 2793
Hash File Calculator (HFC) wanted
I need to perform some performance analysis on a number of server jobs which use hashfiles. I recall there is an unsupported utitlty (HFC) to check for the correct settings for the hashfile. Does anyone have a copy of the utility which they can send me or provide a link from where it can be download...
- Fri May 30, 2008 10:04 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ETLStats - how to obtain correct link counts for PX jobs
- Replies: 1
- Views: 1962
ETLStats - how to obtain correct link counts for PX jobs
I trying to run the job DSJobReportDb within the ETLStats suite. I'm trying to obtain the row count for a parallel job. But since the parallel job has been run on 4 nodes and I'm finding that the row counts in the table ETL_ROW_HIST contains the values for only 1 partition instead of the complete lo...
- Fri May 30, 2008 5:54 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ETLStats - Hash file does not exist: BuildParamHash
- Replies: 2
- Views: 1781
ETLStats - Hash file does not exist: BuildParamHash
I'm trying to run ETLStats.
I've followed the install instructions and am trying to run job SeqJobStatus.
But this is call job DSJobReportDbDriverNoWait, but is aborting with
Failed: Hash file does not exist: BuildParamHash.
How does this hashile get created?
I've followed the install instructions and am trying to run job SeqJobStatus.
But this is call job DSJobReportDbDriverNoWait, but is aborting with
Failed: Hash file does not exist: BuildParamHash.
How does this hashile get created?
- Fri May 30, 2008 2:42 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Determine end of input data
- Replies: 14
- Views: 6281
- Thu May 29, 2008 10:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Determine end of input data
- Replies: 14
- Views: 6281
Ok I've tried to use an Aggregator stage. The input columns to the stage are : '1' = Key1 @INROWCOUNT = wk_Input_Row @OUTROWCOUNT = wk_Output_Row In the Aggregator stage I am grouping my Key1, and getting the maximum values for the other 2 columns. But the output from the Aggregator stage seems to b...
- Thu May 29, 2008 7:32 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Determine end of input data
- Replies: 14
- Views: 6281
Determine end of input data
Background: We have several simple jobs which read a source table/sequential file and output the data to a target table via a transformer. Requirement: Write a row to a common audit table ehich includes the input and output row count columns: Issue: I was thinking a simply insterting a into the aud...
- Fri Dec 28, 2007 11:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Access repository information
- Replies: 2
- Views: 2058
Access repository information
I've just started to use DataStage v8, and have been asked to produce a text file with the details as shown in Director.
Does anybody know how I can retrieve this information? I believe in previous versions, this used to be stored in UV tables.
Does anybody know how I can retrieve this information? I believe in previous versions, this used to be stored in UV tables.
- Thu Dec 27, 2007 5:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue reading Oracle NUMBER datatype column
- Replies: 3
- Views: 3054
- Thu Dec 27, 2007 4:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue reading Oracle NUMBER datatype column
- Replies: 3
- Views: 3054
Issue reading Oracle NUMBER datatype column
I have a simple parallel job which is reading an Oracle table and via a transformer stage to load a Netezza table using the Netezza enterprise. The issue I'm having is that the job is raising warnings when Oracle stage is reading a NUMBER datatype column. The job is raising the following warning :- ...