Search found 42189 matches

by chulett
Sat Jul 09, 2011 10:10 am
Forum: General
Topic: help required in routine
Replies: 40
Views: 12214

So, is there any equivalent function available in 7.x for finding recent starting event id? i don't think we can get the recent starting event via DSGetNewestLogID. Because it returns the last event of the recent run Of course there is a way and it's what I've been harping on you about from the beg...
by chulett
Sat Jul 09, 2011 9:48 am
Forum: General
Topic: help required in routine
Replies: 40
Views: 12214

Ah... that's an 8.x function, hence the "never dimensioned" error when you try to use it in a 7.x environment.
by chulett
Sat Jul 09, 2011 9:01 am
Forum: General
Topic: help required in routine
Replies: 40
Views: 12214

In the documentation I linked, it's given as: int DSGetLogEventIds( DSJOB JobHandle , int RunNumber, char * Filter, char ** List ); So the "List" of returned IDs is one of the function arguments, the "int" it shows holds the returned status of the function call. Return Values If ...
by chulett
Sat Jul 09, 2011 7:53 am
Forum: General
Topic: help required in routine
Replies: 40
Views: 12214

Yes. Reread the syntax for the DSGetLogEventIds function at the link provided, you are not calling it correctly.
by chulett
Fri Jul 08, 2011 9:10 pm
Forum: General
Topic: help required in routine
Replies: 40
Views: 12214

Seriously? I'm not sure how many more ways I can explain it without writing the code for you. Did you check the documentation link I posted?
by chulett
Fri Jul 08, 2011 8:45 pm
Forum: General
Topic: help required in routine
Replies: 40
Views: 12214

In case you are still looking for some documentation.
by chulett
Fri Jul 08, 2011 10:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problems using File Pattern option with DataStage in Windows
Replies: 9
Views: 5315

I don't have a sample that comes close to your situation, but I do have a question for our gurus: If the OS is Windows, does that mean that the DS runtime environment is running on a Windows server, or is it still on a Unix server? If you are talking about the choice of OS you have when creating a ...
by chulett
Fri Jul 08, 2011 8:52 am
Forum: General
Topic: Executing dsjob command from routine activity
Replies: 28
Views: 10541

samyamkrishna wrote:so changing it to -wait instead of -jobstatus will solve this too right?
Yes, without the need for any extra checks.
by chulett
Fri Jul 08, 2011 7:52 am
Forum: General
Topic: Executing dsjob command from routine activity
Replies: 28
Views: 10541

Well... I never said to uncheck anything. I said to modify your sequence in a specific way which it sounds like you did not do. Also, dsjob with -wait will not return a 1 or a 2, it will return a zero or a non-zero (as in negative) status with the latter being a failure of some kind. You must be usi...
by chulett
Fri Jul 08, 2011 7:24 am
Forum: General
Topic: help required in routine
Replies: 40
Views: 12214

So... go ahead. Make it so. :wink:
by chulett
Fri Jul 08, 2011 7:13 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error when removing Leading zeros from a numeric data
Replies: 4
Views: 2243

So I guess you missed the inner StringToDecimal function?

Regardless, as noted one can simply trim them off rather than going through that double-conversion.
by chulett
Fri Jul 08, 2011 7:10 am
Forum: General
Topic: help required in routine
Replies: 40
Views: 12214

Then why are you looking for ANY "newest" id (which will get you the most recent log entry) and then going backwards to the beginning of everything in the log? As noted, you tell the DSGetNewestLogId function what type of newest id you want so there are a couple of approaches that would be...
by chulett
Fri Jul 08, 2011 6:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle Connector Stage - ORA 1406
Replies: 12
Views: 79681

Did you look up what exactly an "ORA-1406" means? A quick google for that returned lots of hits that explained it and detailed ways people have dealt with it. It has also been discussed here several times.
by chulett
Fri Jul 08, 2011 6:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Dynamic Queries in ODBC stages
Replies: 9
Views: 2148

Since your source is a database, I actually meant what I said - a work table so the join can be done in the source and you extract just what you need. Your way still means everything will be extracted and then the join would get you the proper results. Both ways would work, of course, but pushing th...