Search found 53125 matches

by ray.wurlod
Wed Apr 17, 2013 1:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: To read all data from an CSV file and then populate into xml
Replies: 5
Views: 1762

Note that I did not suggest using a server job.
by ray.wurlod
Tue Apr 16, 2013 11:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Conditional Deletion
Replies: 22
Views: 5872

Create a sequence to run them all, then the client has only the one "job" with which to interact.
by ray.wurlod
Tue Apr 16, 2013 11:44 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Using mkdbfile in a Unix script - foreground & backgroun
Replies: 9
Views: 4246

Not really. The trailing & still means "create a background process" in ksh, and the nohup simply specifies not to wait for it to finish. What exactly do you mean by "hangs"? The mkdbfile command works perfectly well in a background process in my experience, provided its synt...
by ray.wurlod
Tue Apr 16, 2013 11:42 pm
Forum: General
Topic: ExecDOS Command
Replies: 10
Views: 3527

bob7027 wrote:bash file is executing perfectly but the expected output is wrong
You're executing a bash script using ExecDOS ?

Or do you mean a batch file?

Still waiting to see what you've put in the Input Value field.
by ray.wurlod
Tue Apr 16, 2013 11:37 pm
Forum:
Topic: IMAM - importing an Oracle table def
Replies: 8
Views: 5687

Keep in mind that Connectors typically install on the Engine tier while bridges install on the Client tier. If these are different machines you will definitely need separate Metadata Interchange Servers defined - one for bridges and one for Connectors.
by ray.wurlod
Tue Apr 16, 2013 11:37 pm
Forum:
Topic: IMAM - importing an Oracle table def
Replies: 8
Views: 5687

Keep in mind that Connectors typically install on the Engine tier while bridges install on the Client tier. If these are different machines you will definitely need separate Metadata Interchange Servers defined - one for bridges and one for Connectors.
by ray.wurlod
Tue Apr 16, 2013 6:26 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Why use orchadmin to delete datasets?
Replies: 10
Views: 8218

Nagaraj has it wrong. A Data Set consists only of the descriptor file and its associated segment (data) files. There are no "control" files (this term is sometimes used to refer to the descriptor file). There are no separate header files. Each segment (data) file has its own internal head...
by ray.wurlod
Tue Apr 16, 2013 6:25 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Using mkdbfile in a Unix script - foreground & backgroun
Replies: 9
Views: 4246

Try preceding the mkdbfile command with nohup so that its controller can return straight away.

Test this in the Administrator client command window, preceded by SH -c.

Code: Select all

SH -c "nohup $DSHOME/bin/mkdbfile name options &"
by ray.wurlod
Tue Apr 16, 2013 6:22 pm
Forum: General
Topic: Sharing datastage project
Replies: 3
Views: 953

In general what you have outline is not possible, for the reasons Andy gave.

But you could create protected projects - non-editable copies of your primary base project.
by ray.wurlod
Tue Apr 16, 2013 6:20 pm
Forum:
Topic: IMAM - importing an Oracle table def
Replies: 8
Views: 5687

IMAM, as far as I can determine, is the import tool of choice where a metabroker or bridge is required. It supersedes Import/Export Manager in this role (though I still prefer the IEM command line for some things). Importing table definitions does not require a metabroker or bridge. It uses the Conn...
by ray.wurlod
Tue Apr 16, 2013 4:22 pm
Forum: General
Topic: ExecDOS Command
Replies: 10
Views: 3527

Show us the method you are using in DataStage. For example are you using a before-job subroutine to invoke ExecDOS? If so, what are you putting into the Input Value field?
by ray.wurlod
Tue Apr 16, 2013 4:20 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Why use orchadmin to delete datasets?
Replies: 10
Views: 8218

Open the Data Set Management tool in DataStage Designer. Open any of your valid Data Sets. The tool will show you the contents of the descriptor file (the *.ds file). It also shows the location and names of the segment files on each node (as you select each node) that contain the data. Nagaraj has i...
by ray.wurlod
Tue Apr 16, 2013 4:14 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Transformer Loop - data for related records
Replies: 1
Views: 791

Welcome aboard.

DataStage is really set up to stream data through it. Recursion and going back multiple levels is not really supported, without multiple passes over the data.
by ray.wurlod
Tue Apr 16, 2013 4:10 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: issue in using date_from_string in modify stage
Replies: 3
Views: 959

The first argument of date_from_string must be the name of a column on the input link.

Not a constant.

Not a job parameter.

Not anything else.
by ray.wurlod
Tue Apr 16, 2013 4:07 pm
Forum:
Topic: IMAM - importing an Oracle table def
Replies: 8
Views: 5687

Normally one imports table definitions through a tool such as DataStage Designer or Information Analyzer.