Search found 53125 matches

by ray.wurlod
Fri Jul 15, 2011 3:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: dummy stage
Replies: 2
Views: 936

Copy stage.

Note, however, that Peek will not "fill up your log" - it will capture only the sample you specify (by default 10 rows per node).
by ray.wurlod
Fri Jul 15, 2011 3:35 am
Forum: General
Topic: Finding the projects,jobs,logs in unix
Replies: 13
Views: 3717

Code: Select all

cd `cat /.dshome`
. ./.dsenv
bin/dssh "SELECT @ID, PATH FROM UV.ACCOUNT WHERE @ID NOT IN ('UV', 'uv', 'DS', 'ds');"
by ray.wurlod
Thu Jul 14, 2011 8:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: warning :field not present in the output interface
Replies: 5
Views: 17126

You've asked the stage to keep (perhaps by failing to ask the stage to drop) these two fields, but have not provided these fields on the output link of the stage. The solution is obvious.
by ray.wurlod
Thu Jul 14, 2011 8:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: CPU its Cores and Nodes
Replies: 6
Views: 2172

There is no single ideal setup. But, if there were, it would not have disk and scratchdisk resource specified in the default locations; it would have these spread over as many disks as possible and those disks would have plenty of free space.
by ray.wurlod
Thu Jul 14, 2011 3:26 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Config file with Conductor & computing nodes setup probl
Replies: 4
Views: 1566

You must have the conductor node mentioned at least once, and it must really be in the default node pool ("") too.
by ray.wurlod
Thu Jul 14, 2011 3:17 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: incoming .csv file with embedded line breaks
Replies: 5
Views: 3403

What Craig suggested is done in the grid on the Columns tab.

It requires that the strings containing the newline characters are quoted.
by ray.wurlod
Thu Jul 14, 2011 1:08 am
Forum: General
Topic: Number of stages in Job sequences
Replies: 10
Views: 2750

Code: Select all

cd '&COMO&' 
or

Code: Select all

cd \&COMO\&
by ray.wurlod
Thu Jul 14, 2011 1:06 am
Forum: General
Topic: Difference between dsx files of version 7 and 8
Replies: 11
Views: 2409

Let's wait to see how fmou fares...
by ray.wurlod
Wed Jul 13, 2011 5:38 pm
Forum: General
Topic: Difference between dsx files of version 7 and 8
Replies: 11
Views: 2409

You may be able to hack it (by changing the Tool Version field) in this case, but nothing is guaranteed.
by ray.wurlod
Wed Jul 13, 2011 5:37 pm
Forum: General
Topic: Passing commandoutput as a parameter in to the parameter set
Replies: 14
Views: 5567

You can not use activity variables as values for parameters, whether they're in parameter sets or not. You need to provide the activity variable reference when setting the value of a parameter, for example within the Job tab of a Job activity or via a -param option on a dsjob command line.
by ray.wurlod
Wed Jul 13, 2011 5:32 pm
Forum: General
Topic: Read records from a file based on index files byte position
Replies: 15
Views: 4779

Here's how I would go about it. Search DSXchange for code for OpenSequentialFile, which handles all file opening problems. Some error handling has been omitted for clarity. FUNCTION ReadPartOfFile(aStartPosition, aEndPosition) DEFFUN OpenSequentialFile(FilePath, OpenMode, WriteMode, LogMode) Calling...
by ray.wurlod
Wed Jul 13, 2011 5:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Extracting SQL Server VARCHAR(MAX)
Replies: 2
Views: 2273

The convention here at DSXchange is that, when you resolve a problem, you mark it as resolved AND make a post indicating how it was resolved.

You have done the former but not yet the latter.
by ray.wurlod
Wed Jul 13, 2011 5:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Can we connect to ODBC source using DNS instead of IP
Replies: 1
Views: 999

Yes. In fact most sites use host names rather than IP addresses in .odbc.ini.
by ray.wurlod
Wed Jul 13, 2011 5:14 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Type 1 and Type 2 co-exist in SCD
Replies: 1
Views: 1032

No, because there is no Type2 change to warrant creating a new record.
by ray.wurlod
Wed Jul 13, 2011 5:10 pm
Forum: General
Topic: Many projects require different db clients on 1 DS engine
Replies: 5
Views: 2359

For ODBC you can have project-based uvodbc.config files. For other database connectivity use project-based environment variables (for example DB2INSTANCE or ORACLE_HOME).