DSXchange

At this point, I would just like to get the Locate statement to work with any array. The Datastage help does not seem to be helpful.

Locate '172' IN '172,200,201,200,202' SETTING Ans
Else Ans = 'Not Found'

This is what I would like to get to work.

Hello all, It is my understanding that the Locate statement can search an array. In order for me to use it in a routine, I have to specify a position. Well that defeats the purpose. Shouldn't it search by field? Otherwise, I have to spin it thru a loop and read one position at at time looking for a ...

The force compile did the trick! :shock: True to your words, those irritating warnings went away. I didn't notice it sitting there under the File menu. I tried the RCP disable first but the job aborted. I will keep that trick in mind for the future as it may flush out other issues. Thanks for that. ...

That will be the first thing I try on Monday. I get a three day weekend!

Thanks Kris

Ken

Here's the warnings. The join stage name is GetAlongOthers. The columns that I deleted from the stage are "HOLD_IND", "SHR_TBL_STA_IND", and "CNFLT_STA_CDE". 1) GetAlongOthers: When checking operator: Dropping component "HOLD_IND" because of prior component wi...

Here's the warnings. The join stage name is GetAlongOthers. The columns that I deleted from the stage are "HOLD_IND", "SHR_TBL_STA_IND", and "CNFLT_STA_CDE". 1) GetAlongOthers: When checking operator: Dropping component "HOLD_IND" because of prior component wi...

This may be a DataStage issue. In the beginning, there was a join stage. And it was generating warnings such as: "JoinStage_1: When checking operator: Dropping component "Column_x" because of prior component with same name". I traced this to mean that there were duplicate column ...

Great! This is good stuff. I appreciate the feedback.

I am not used to working in Px so pls bear with. I have to work thru a host of warning as well so you may see some more posts. I will try to find answers thru searches before posting.

Kind Regards,
Ken

Thanks for the reassurance. I know I can perform mathimatical calculations on the column so it must be numeric. I just needed some light shed on the weirdness of the format of ' 0001.' with the preceding space. As long as it gets to and from the database as numeric, I should be fine. Thanks again. K...

Hello people! I am going crazy here. I can't figure out why I am seeing decimal data in the format of " 000011." when viewing from a data set or a OCI. The Oracle 10 database has this column as a decimal(11) with no scale. So I should see a clean looking number, yes? Any ideas will be so g...