Search found 179 matches

by PilotBaha
Thu Dec 18, 2008 12:09 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Functions and routines read only?
Replies: 7
Views: 2099

Chris,
poor choice of words for me. :) Mike thanks for the tip..

Baha
by PilotBaha
Thu Dec 18, 2008 11:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Functions and routines read only?
Replies: 7
Views: 2099

Functions and routines read only?

Be gentle, i took a year off from DS world. :)
I see that functions and routines delivered with software is ready only now. (i.e you cannot see the code). Is that the norm with 8.0 or is it because the software was setup that way?

It was really helpful to see the code to generate other code.. :)
by PilotBaha
Wed Dec 17, 2008 1:15 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: CFF and merging records back together
Replies: 4
Views: 1472

Craig, that also crossed my mind. Creating some stage var with SeqNum = SeqNum +1 type of derivation and an initial value of 1. I won't need to check the max value from the database as these records will be used one time and they will be for my internal processing. For some reason i remember this me...
by PilotBaha
Wed Dec 17, 2008 12:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: CFF and merging records back together
Replies: 4
Views: 1472

CFF and merging records back together

I have a CFF stage that's receiving data from a COBOL copy book with REDEFINES and OCCURS clauses. (Brings back memories from old days). What i'd like to do is to produce some kind of a sequential record number so that i can match the records together later on. To give you an example here's the inpu...
by PilotBaha
Mon Jun 04, 2007 4:36 pm
Forum: IBM QualityStage
Topic: Latitude and Longitude from address
Replies: 1
Views: 1699

Geolocator, which I haven't worked with for about 2 years, had a very primitive documentation. If this is the same case, then you'd get an output file in txt format which you have to later capture the Lat/Long.
by PilotBaha
Wed Feb 28, 2007 4:33 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Varchar issues..
Replies: 7
Views: 2788

How do you propose to source "(whatever the size of the target field is)"? Ray, that IS the challenge. I mean I will have the target data structure in the metadata definition. The challenge i am facing is to use that definition in the conditional statement that needs to be put inside the ...
by PilotBaha
Wed Feb 28, 2007 1:36 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Varchar issues..
Replies: 7
Views: 2788

Unfortunately, there is no builtin or documented way to do this dynamically. The column information is stored in the job details and (if used) in the table definitions file. Neither location is documented or described by Ascential. Instead of "hacking" that information from the repository...
by PilotBaha
Wed Feb 28, 2007 1:32 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Varchar issues..
Replies: 7
Views: 2788

.... Use a constraint expression in the Transformer stage to direct rows where it is of the appropriate size onto one output link, and use a reject or alternative output link to capture the rows with an oversized column. Ray, that's fine and dandy when you are dealing with one or two columns of dat...
by PilotBaha
Fri Feb 23, 2007 8:45 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Varchar issues..
Replies: 7
Views: 2788

Varchar issues..

I am reading Comma delimited file using Sequential file stage.I defined one column length as 20.But some times i am getting data for that column more than 20 like 25.Still the job is running by truncating the remaining 5 characters.Is there any way to check the length of the field dynamically? What ...
by PilotBaha
Wed Mar 22, 2006 7:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Blanks in parameter values
Replies: 2
Views: 1195

Ray,
after I posted this error, I realized this could be a in-house problem. We have 3 different scripts to run a dsjob command and handle the parameter build for -param generation. I think this is a problem in our parameter building process rather than the DS issue.

Thanks anyway..

Baha
by PilotBaha
Wed Mar 22, 2006 6:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Blanks in parameter values
Replies: 2
Views: 1195

Blanks in parameter values

We just recently discovered that parameters supplied to dsjob scripts like InWord="Blanks are problem" create an issue. If the assignment is InWord="Blanksareproblem" it works fine. What would be the recommendation to solve this issue? (I did use the search function but couldn't ...
by PilotBaha
Mon Dec 12, 2005 5:57 pm
Forum: Site/Forum
Topic: New Forum
Replies: 11
Views: 7714

Is there any intention of putting together another class? I couldn't make it to the Ascential World..
by PilotBaha
Wed Dec 07, 2005 6:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: filter operator requires more output ? Really?
Replies: 4
Views: 4887

filter operator requires more output ? Really?

This is the error I get from the Director: Filter_9,0: The filter operator requires more outputs than it has been configured for; it has 1, it needs 2. Why would it need 2 outputs? By the way, Output Rejects = False. When I change it to "True" and add a reject link out, it increases the va...
by PilotBaha
Wed Nov 30, 2005 4:48 am
Forum: Site/Forum
Topic: Get moving folder for members :)
Replies: 3
Views: 3178

Get moving folder for members :)

Looking at the pictures from LV convention and looking at the mirror, i say we should open an area where we can talk about shedding some pounds/kilos :)
by PilotBaha
Tue Nov 15, 2005 4:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to implement control break in PX?
Replies: 8
Views: 3549

Opps placed the SVs in wrong sequence.. Now it's working..

Thanks for all the help..