DSXchange

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 ...

I have found a possible solution, by running the following awk script on the filter option of the sequential file stage :- awk 'BEGIN{FS=",";OFS=","}{gsub("\"\"","",$2)}1' This script basically strips out the quotes within column 2. Though this has f...

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...

Thank to everyone for their comments.

With regards to csri suggestion, what would happen if the column contained commas?

eg,

Address
--------------
"5 My street, Big town"


I am still surprised why DataStage cannot automatically handle these situations!!!

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"", "...

Unfortunately we do not have the CDROM's.

IBM have just been provided us with the tar files for the server and client.

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...

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...

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?

Is ETLStats still applicable for DataStage v8? I mean are thier other, dare I say 'better', methods within v8?

I would still be interested in knowing the answer to my aggregate question. I can I ensure the aggregate is done over the complete data as opposed to a partition.

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...

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...

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.

ArndW, thank you for the quick response.

It sounds like this is a know issue. Just to verify I need to create a message handler to demote the warning message to informational.

Is there another way to surpress the warning without creating a message handler?

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 :- ...