Search found 53125 matches

by ray.wurlod
Wed Jun 11, 2008 4:53 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Is it possible to automate the DataStage export of an entire
Replies: 12
Views: 4601

Yes it is. Search DSXchange for dscmdexport command, possibly in combination with "BAT".
by ray.wurlod
Wed Jun 11, 2008 4:51 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: could not open director
Replies: 3
Views: 1128

Just in the one project?

How long do you wait until you decide that it is hanging?

What was the last time someone successfully used Director with this project? Did they change the settings, perhaps to disable display of categories? How many jobs are there in the project?
by ray.wurlod
Wed Jun 11, 2008 4:48 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Command to import table definition from Sequential File?
Replies: 1
Views: 1380

Welcome aboard. I am not aware of any such routine. The structure of the tables in which table definitions are stored is not documented. Further, the table definition must be stored twice, once in the project's local repository and once in the common Information Server repository. You would be well ...
by ray.wurlod
Wed Jun 11, 2008 4:39 pm
Forum: General
Topic: Connecting Datastage to Unidata on a different server
Replies: 1
Views: 1152

Welcome aboard.
Verify any differences in the uvodbc.config files in the projects on the two machines. If you are using ODBC for connectivity also verify any differences between how the ODBC DSNs are set up.
by ray.wurlod
Wed Jun 11, 2008 4:30 pm
Forum: General
Topic: sequential operator cannot preserve the partitioning
Replies: 2
Views: 5126

DSXchange has a Search facility which you could have used to find this answer.
by ray.wurlod
Wed Jun 11, 2008 1:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Spaces in File Pattern Pathname
Replies: 1
Views: 831

Spaces in File Pattern Pathname

Found and solved a curious happenstance today. Using File Pattern property in Sequential File stage, where a folder in the pathname contained spaces in its pathname, View Data (and job run) returned an incorrect error indicating that no files matching the pattern could be found. Changing from the lo...
by ray.wurlod
Wed Jun 11, 2008 1:33 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Is it possible to assign an amount of RAM for Datastage?
Replies: 8
Views: 2210

Try starting DataStage services before you start tomcat.

DataStage only takes the memory it needs, using specialized malloc() and free() calls.
by ray.wurlod
Wed Jun 11, 2008 12:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Virtual Hash files , Distributed Hash file
Replies: 4
Views: 1207

Where did you come across these terms? My guess is that a virtual hashed file (never "hash" file) is one that is cached in memory. A Distributed File is a UniVerse construct that is also available in DataStage; it is a logical way to provide an "umbrella" containing multiple standard hashed files th...
by ray.wurlod
Tue Jun 10, 2008 11:10 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DSjobreport error on passing arguments
Replies: 1
Views: 1307

Does this folder actually exist?

Try it without the trailing delimiter, that is C:\Temp
by ray.wurlod
Tue Jun 10, 2008 11:08 pm
Forum: General
Topic: DataStage Backup and Recovery from Server
Replies: 21
Views: 18305

Let's say you delete a job and need to restore it. Please explain the process. You know the job name but no other information.
by ray.wurlod
Tue Jun 10, 2008 9:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Switching between sequence and job
Replies: 22
Views: 5135

Yes.

You would need to parse them out of the $UserStatus activity variable, probably using Field() functions.
by ray.wurlod
Tue Jun 10, 2008 8:37 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DSD.UVOpen mkdbfile: error initializing file
Replies: 12
Views: 11820

The most usual reason is that the file system is full, a quota on the directory has been exceeded, or that you lack read, write and execute permissions to the directory.
by ray.wurlod
Tue Jun 10, 2008 6:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Buffer Overflow Reading Input Record Contining HEX 00 Value
Replies: 3
Views: 986

Try changing APT_STRING_PADCHAR to something other than 0x00 (for example 0x20 which is a space character). This may or may not work.
by ray.wurlod
Tue Jun 10, 2008 6:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Replacing digit with characters
Replies: 2
Views: 829

You don't need to code in C++; you can use an expression in a Transformer stage. To preserve the multiple leading zeroes you will need to specify the field as VarChar rather than decimal or numeric. The expression is likely to be a three-level If..Then..Else construct. Use stage variable to test the...
by ray.wurlod
Tue Jun 10, 2008 5:00 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: File Showing wrong count
Replies: 3
Views: 1078

The header IS a row, and therefore is properly included in the row count, if "First line is column names" is False.