Search found 42189 matches

by chulett
Sun Dec 01, 2013 11:59 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: uploading a value to job parameter
Replies: 5
Views: 2345

Sorry, a little lost. Not sure what you mean by 'upload' or 'local'. Is the local parameter a job parameter? And this column value, is it something you are selecting / deriving in a job and need to pass to another job? Or use it somehow in the same job?

More details would help.
by chulett
Sun Dec 01, 2013 10:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: IsNotNull in transformer stage - won't compile
Replies: 9
Views: 2768

No worries... if everybody followed all of the rules and put everything right where it belonged the first time, I'd be out of a Moderator job. :D Speaking of which, use the Reply with quote option when there's a reason to quote something, say several posts down the road when you are replying to some...
by chulett
Sun Dec 01, 2013 10:13 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: IsNotNull in transformer stage - won't compile
Replies: 9
Views: 2768

I'm assuming the error you saw with the IsNotNull() function was similar? That it wants you to check an input field rather than the results of a composite function call? If so, seems to me you'd need to store the result of the Field() function in a stage variable and then do a separate null check.
by chulett
Sun Dec 01, 2013 10:09 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: IsNotNull in transformer stage - won't compile
Replies: 9
Views: 2768

Well... you did mark the job type as Server and posted in the Server forum. :wink:

Let's start by getting you into the proper forum... and here we are.
by chulett
Sun Dec 01, 2013 9:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: IsNotNull in transformer stage - won't compile
Replies: 9
Views: 2768

Parallel function only. Use Not(IsNull(xxxx)) in a Server job. Or you could write your own. :wink:
by chulett
Fri Nov 29, 2013 9:11 am
Forum: General
Topic: C++ compiler for DS v9.1
Replies: 4
Views: 1515

1. Authorized Users would be named licenses, one specific to each person that will need to compile something. 2. Concurrent Users is where you license the number of simultaneous users that the compiler would support, regardless of user. For example, you could use #2 to license 1 concurrent user that...
by chulett
Fri Nov 29, 2013 9:02 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to pass data value to next PX job parameter?
Replies: 7
Views: 2660

True... if both jobs need the same parameter. The question here, however, was how can the first job (which generates a value) pass that value to the second job. With the User Variables stage, the first job could be dropped from the process but (as you noted) would require the use of a Sequence job, ...
by chulett
Fri Nov 29, 2013 8:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Field delimiter in EBCDIC
Replies: 6
Views: 3000

Try '0xBB' rather than '\xBB'. And you should be using the CFF stage for this.
by chulett
Thu Nov 28, 2013 4:20 pm
Forum: General
Topic: environment variables in routine
Replies: 4
Views: 1337

One discussion here, there are others:

viewtopic.php?t=120571
by chulett
Thu Nov 28, 2013 3:10 pm
Forum: General
Topic: environment variables in routine
Replies: 4
Views: 1337

A little lost. Environment variables don't need to be 'passed' but are fetched from the environment. Search here for 'GetEnvironment' for examples of the function needed.
by chulett
Thu Nov 28, 2013 3:05 pm
Forum: General
Topic: Writing job log event entries repeatedly to the file
Replies: 13
Views: 2821

Same principle, though.
by chulett
Thu Nov 28, 2013 1:20 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Field delimiter in EBCDIC
Replies: 6
Views: 3000

I believe you should be able to specify the hex value as the field delimiter string.
by chulett
Thu Nov 28, 2013 1:09 pm
Forum: General
Topic: Write DataStage logs to a file (During Execution)
Replies: 4
Views: 3216

It was specifically the whole concept of 'redirection during execution' that I was noting was not really possible. Of course, the log contents can be captured and written elsewhere, plenty of discussions on that topic here... your wrinkle on that is the 'real time' component. Neither of us mentioned...
by chulett
Thu Nov 28, 2013 12:23 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to process one row at a time using Java Integration?
Replies: 7
Views: 2095

I was going to suggest that but felt it might be too sacrilegious for this forum. :wink: And wasn't sure if it supported the Java Integration stage.
by chulett
Thu Nov 28, 2013 11:59 am
Forum: General
Topic: Writing job log event entries repeatedly to the file
Replies: 13
Views: 2821

We had this same 'control character' conversation back in your "Extract of log file using DSGetLogEntry not working" thread. :wink: