Search found 42189 matches

by chulett
Wed Jun 25, 2014 3:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Expected identifier; got: "*"
Replies: 6
Views: 4014

I would suggest you get rid of IsValidDate() and switch to IsValid() with the 'date' type as the former will log an error when a date is invalid while the latter will not. Plus you should also be checking the validity of the string and only converting it to a date if the validity check succeeds. I'm...
by chulett
Wed Jun 25, 2014 2:14 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: want to delete datasets using orchadmin
Replies: 3
Views: 771

Basically it is "orchadmin delete" but I'm guessing this is more about the three months part. If you mean three months since it was created or modified, you can use find for that and then send them to orchadmin one by one.
by chulett
Wed Jun 25, 2014 1:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: IN logic in Datastage
Replies: 6
Views: 2079

The values are in a job parameter according to the original post, so there's no need to change the job for a values change.
by chulett
Wed Jun 25, 2014 1:29 pm
Forum: General
Topic: Excel reading in ds 8.7
Replies: 2
Views: 1129

Plenty of light already available if you search.
by chulett
Wed Jun 25, 2014 1:28 pm
Forum: General
Topic: Incorrect Elapsed Time
Replies: 3
Views: 1308

That would make sense... a little over four minutes time differential if so.
by chulett
Wed Jun 25, 2014 9:54 am
Forum: General
Topic: Incorrect Elapsed Time
Replies: 3
Views: 1308

That's certainly... odd. Contact your official support provider.
by chulett
Wed Jun 25, 2014 8:56 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Universe Files, SDK Sequences and Q-Pointers
Replies: 4
Views: 3966

All of that will work just as it does now in the new version.
by chulett
Wed Jun 25, 2014 7:26 am
Forum: General
Topic: Error creating a project
Replies: 6
Views: 2190

Perhaps this will help:

viewtopic.php?p=149952
by chulett
Wed Jun 25, 2014 7:03 am
Forum: General
Topic: Run Powershell from Execute Stage
Replies: 7
Views: 5474

mgsteiner wrote:Can it be credentials problems ?
Looks like that may be the case. Check the last post in this thread and see if that helps.
by chulett
Wed Jun 25, 2014 6:59 am
Forum: General
Topic: Run Powershell from Execute Stage
Replies: 7
Views: 5474

I removed my post after you answered with your details as I was obviously wrong. I was basing my assumption on the wording in your initial post and the fact that you were on Windows, never mind that it is very early in the morning for me. There is an actual stage named the Command Stage which only c...
by chulett
Wed Jun 25, 2014 6:50 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Performance stats and no. of rows in source does not match
Replies: 7
Views: 3615

However, even with a destructive overwrite down to 20 going on it would still show 256 going in, which is what I'm assuming is meant by 'processed'. The surprise people get is when they pull the records back out. :wink: As to the issue, if I had to guess (and I do) the fact that the problem comes wh...
by chulett
Wed Jun 25, 2014 6:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: IN logic in Datastage
Replies: 6
Views: 2079

Isn't this simply an Index() function call?
by chulett
Tue Jun 24, 2014 4:31 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: FTP - ASCII vs Binary
Replies: 6
Views: 2537

ASCII transfers are needed to convert the line terminators between systems, UNIX (LF) to Windows (CR/LF) or vice versa. Binary transfers don't change anything during the transfer. Or if you know the file is meant for Windows, create it on the UNIX server as a "DOS" file and then you can us...
by chulett
Tue Jun 24, 2014 8:47 am
Forum: General
Topic: Error Calling Subroutine DSR_EXECJOB
Replies: 4
Views: 1637

Get your official support provider involved ASAP.

Any idea what happened or changed? Did a filesystem fill up? Are there any other messages or more to this one?
by chulett
Tue Jun 24, 2014 6:16 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Anonymous PL/SQL Block
Replies: 3
Views: 3607

8)