Search found 53125 matches

by ray.wurlod
Fri Apr 24, 2009 3:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: the record is too big to fit in a block
Replies: 12
Views: 12678

Look better.

It's in the Parallel folder (not in any of its sub folders).

Default default value is 131072.
by ray.wurlod
Fri Apr 24, 2009 4:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Splitting of Values into 2 or more lines
Replies: 9
Views: 5761

If you're prepared to use a server job this is a very easy task.

Code: Select all

Convert(@TM,@FM,Fmt(InLink.TheString,"8L"))
and write to a text file.
by ray.wurlod
Fri Apr 24, 2009 1:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Compiler for DS 7.5x2
Replies: 2
Views: 694

... and it's NOT free.
by ray.wurlod
Fri Apr 24, 2009 1:42 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Any reason to perform a daily backup of jobs
Replies: 2
Views: 1165

Murphy (of Murphy's Law fame) was an optimist.

If you have a backup, nothing will go wrong. When something goes wrong, that's the time you won't have a backup.
by ray.wurlod
Fri Apr 24, 2009 1:40 am
Forum: General
Topic: I wanted to know the model of the exam papers
Replies: 2
Views: 1033

There are sample questions on the IBM certification web site.
by ray.wurlod
Thu Apr 23, 2009 10:50 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: creating dsn through unix console
Replies: 1
Views: 566

The best tool to use is vi (the editor).

You need to edit the file .odbc.ini (whose location is given by $ODBCINI) and you also need to edit the file uvodbc.config in your project. You may also choose to edit the global uvodbc.config file in the DataStage server engine directory.
by ray.wurlod
Thu Apr 23, 2009 9:57 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to handle scratch space error
Replies: 4
Views: 1024

The default configuration file is called default.apt. Other configuration files may exist on your system. They can be seen using the Configurations editor (available from the Tools menu in Designer). Whether you can edit or create configuration files is dependent on security at your site. As for wha...
by ray.wurlod
Thu Apr 23, 2009 4:43 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: the record is too big to fit in a block
Replies: 12
Views: 12678

It doesn't matter where you set it, though the Administrator client only lets you create environment variables in the User Defined folder.
by ray.wurlod
Thu Apr 23, 2009 4:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Identify Jobs that comples with warning
Replies: 9
Views: 2061

"compiles" is a closer match than "completes" (has QualityStage probabilistic matching hat on). For "completes" the easy solution is in Director; disable display of categories in the View menu then sort by Status and/or filter on Status. Print report (perhaps to file) f...
by ray.wurlod
Thu Apr 23, 2009 4:37 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Length of a field in Hash File
Replies: 6
Views: 2149

When you concatenate key columns for a hashed file they must be separated with the declared separator character. If you have not declared an explicit separator character the default separator character is a text mark, accessible via the system variable @TM.
by ray.wurlod
Thu Apr 23, 2009 4:35 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Error using Data Connection in IA
Replies: 16
Views: 9054

WebSphere Application Server is NOT DataStage server.
by ray.wurlod
Thu Apr 23, 2009 2:43 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Error using Data Connection in IA
Replies: 16
Views: 9054

HP Itanium ?
by ray.wurlod
Thu Apr 23, 2009 2:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Identify Jobs that comples with warning
Replies: 9
Views: 2061

If you compile with Multi Job Compile tool you can get a report at the end of which jobs compiled OK, which compiled with warnings, and which failed to compile.
by ray.wurlod
Thu Apr 23, 2009 2:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: warning at LOOKUP
Replies: 3
Views: 1293

Or, if you want to be able to return the duplicates from this link, enable that functionality in the Lookup stage.
by ray.wurlod
Thu Apr 23, 2009 2:39 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to handle scratch space error
Replies: 4
Views: 1024

The only way that scratch space can be increased is to use a configuration file that specifies more scratch space.