Search found 53125 matches
- Fri Nov 17, 2006 7:49 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: E TFDR 000001 (002)- not able to view the data loaded
- Replies: 2
- Views: 1254
- Fri Nov 17, 2006 7:47 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: lookp up stage - fatal error
- Replies: 2
- Views: 1864
- Fri Nov 17, 2006 7:46 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: All objects in the Job become PLUG objects.
- Replies: 9
- Views: 3122
On Solaris that limit is 32K subdirectories in a directory. That would allow in excess of 5000 jobs. Do you really have that many?
Code: Select all
SELECT COUNT(*) FROM DS_JOBS WHERE NAME NOT LIKE '\\%';- Fri Nov 17, 2006 7:43 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to Set Variables in DataStage?
- Replies: 4
- Views: 6900
A User Variables activity in a job sequence allows each variable to be set based on an expression. A stage variable in a Transformer stage similarly allows initialization using an expression. If this variable needs to remain unchanged for each row processed, leave its Derivation field empty. Where i...
- Fri Nov 17, 2006 7:41 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Sequence Hangs
- Replies: 5
- Views: 1333
It you killed it it may not have had the chance to log messages about timeout periods elapsing and so on. Did everything in the sequence get done and the sequence not end, or did it only get part way through the activities it ought to be controlling? You need to inspect all the individual child, gra...
- Fri Nov 17, 2006 7:39 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Pass valus to UNIX script fromDS control job
- Replies: 9
- Views: 1711
- Fri Nov 17, 2006 7:36 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Client Library property required for stage
- Replies: 1
- Views: 1808
- Fri Nov 17, 2006 7:32 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: pass parameter to DSSendmail Subroutine
- Replies: 8
- Views: 2194
- Fri Nov 17, 2006 7:21 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to Pass values from a table to Parameters?
- Replies: 3
- Views: 1084
You have to get the parameter value from the table. That's one job, that has to store the value somewhere accessible, such as its user status area. The second job has to be passed two values decoded from that pathname. You could use Field() functions, or FinalDelimitedString() routine - search the F...
- Fri Nov 17, 2006 7:17 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Intermittent ORA-12545 through sequencer
- Replies: 4
- Views: 2275
Check also for hard-coded settings in the child jobs and for "set to default" settings in the Job activities in the job sequence. Use Set Defaults from the Job menu in Director to set new default values in the new environment or, if you've used $PROJDEF for environment variable job parameters, use A...
- Fri Nov 17, 2006 7:14 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: calculate Job EndDateTime and Job ElapsedTime.
- Replies: 27
- Views: 9719
- Fri Nov 17, 2006 7:12 am
- Forum: General
- Topic: How to export the job log of a particular job?
- Replies: 5
- Views: 3921
- Thu Nov 16, 2006 9:33 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Container Input and Output
- Replies: 2
- Views: 1348
- Thu Nov 16, 2006 9:33 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: calculate Job EndDateTime and Job ElapsedTime.
- Replies: 27
- Views: 9719
- Thu Nov 16, 2006 9:31 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: special character
- Replies: 4
- Views: 1169
So, effectively, the non-printing characters.
will identify that the character is non-printable. The expression returns 1 (true) if the character is non-printable, 0 (false) otherwise. It returns NULL if ch is NULL.
Code: Select all
(Oconv(ch, "MCP") = ch)