Search found 42189 matches

by chulett
Fri May 18, 2012 10:46 pm
Forum: General
Topic: Scheduler issue
Replies: 4
Views: 1312

One time jobs use 'at' and that means that they will only show as 'scheduled' until they run. Re-occurring jobs use 'cron' and will always show as scheduled.
by chulett
Fri May 18, 2012 10:41 pm
Forum: General
Topic: Current timestamp as global variable
Replies: 10
Views: 6196

Have you tried to use the DSJobStartTimestamp macro?
by chulett
Fri May 18, 2012 10:33 pm
Forum: General
Topic: Difference between CLEAR.FILE and CLEAR-FILE
Replies: 10
Views: 3409

Perhaps you should add that so that you might have some idea if there is a problem, what the problem might be. Don't have the syntax for that off the top of my head, perhaps someone else can help...
by chulett
Fri May 18, 2012 10:26 pm
Forum: General
Topic: deletion and compiling DataStage categorioes - from Unix
Replies: 19
Views: 6841

You'd have to query the repository to do that. A dssh query from the command line could:

Code: Select all

SELECT NAME FROM DS_JOBS WHERE CATEGORY = 'xxxxx';
by chulett
Fri May 18, 2012 10:23 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: 421 Timeout (900 seconds): closing connection. 7.5.1A AIX
Replies: 6
Views: 3452

I would suggest you take ftp timeout errors to your Network and/or SysAdmin people for troubleshooting help.
by chulett
Fri May 18, 2012 10:18 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: UtilityHashLookup fails when the hash path is different
Replies: 3
Views: 1752

The routine works only with account-based hashed files, meaning ones that were created in an 'account', i.e. a project and have a VOC record. For pathed hashed files, copy the routine to a new name and change Open to OpenPath.
by chulett
Mon May 14, 2012 1:58 pm
Forum: General
Topic: Issue with Email attachment in Notification Activity
Replies: 2
Views: 2034

Doesn't support wildcards. You'll either need to 'look it up' and then pass it as a parameter each run or write your own email routine that can handle wildcards for the attachment.
by chulett
Mon May 14, 2012 1:09 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: regarding last transaction and current transaction
Replies: 7
Views: 2714

This can be done in DataStage using properly sequenced stage variables, all you are doing is holding on to the previous value of the closingbal for use in the openingbal of the next record.
by chulett
Mon May 14, 2012 7:19 am
Forum: General
Topic: Error while installing Datastage8.5 on windows 2008
Replies: 6
Views: 3065

You should be taking this to your official support provider.
by chulett
Sun May 13, 2012 8:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: warning
Replies: 2
Views: 1206

Seems like the same issue you posted on Friday.
by chulett
Sun May 13, 2012 8:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: delimter error
Replies: 2
Views: 933

Your answer could depend on what your target database is. Use either the StringToDate() or StringToTimestamp() functions, depending.
by chulett
Sun May 13, 2012 9:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Combine columns from Dataset and tables.
Replies: 7
Views: 2249

:!: Please start a new post with your specific issue clearly stated.
by chulett
Sat May 12, 2012 7:36 am
Forum: General
Topic: Pass the value into dsjob command
Replies: 8
Views: 4342

Well... we're not talking echo here but I could be wrong. Have no way to test it, however.