DSXchange

jerome_rajan

Ok, this should work

Left(DecimalToString(col),Index(DecimalToString(col),".",1)+2)

jerome_rajan

Have you by any chance checked the 'Otherwise' checkbox under constraints?

jerome_rajan

Tools --> Options --> General Tab --> Refresh Enabled Checkbox

jerome_rajan

This solution may not be optimal but will serve as a work-around while you search a better solution

Code: Select all

Left(col,Index(DecimalToString(col),".",1)+2)

I haven't actually implemented it. Do let me know if it works.

Note: You might want to add a StringToDecimal just in case

jerome_rajan

Code: Select all

DateToString(StringToDate(col,"%mm/%dd/%yyyy"),"%yyyy-%mm-%dd")

or just use

Code: Select all

StringToDate(col,"%mm/%dd/%yyyy")

assuming your datastage default format is yyyy-mm-dd

jerome_rajan

Parameters get resolved at runtime and not during compilation. If you have used a parameter that is not defined in the Job parameter list, then the job would, most likely, use the name 'AS IS' during runtime.

jerome_rajan

Sparse Lookup is a concept that's based on moving the processing of a join(lookup) to a database. Essentially, DataStage will send your rows in the stream link one by one to the reference DB and the join will be performed in the DB. Since join is a relational concept and does not apply to non-struct...

jerome_rajan

And only for DB2 and Oracle, I believe.

jerome_rajan

Is that a runtime error or is it something you see when you try to view data?

jerome_rajan

Please post the expected and the actual outputs.

jerome_rajan

Thank you. That explains it. Was only trying something Craig mentioned in a different post. Didn't observe that he posted it in the Server forum

jerome_rajan

I tried creating a test job with a transformer at the source and also included a stage variable but the job refused to compile citing the reason as "No input schema available" or something of that sort. Am I doing something wrong?

jerome_rajan

Thanks Craig. That was very informative. I tried creating a test job with a transformer at the source and also included a stage variable but the job refused to compile citing the reason as "No input schema available" or something of that sort. guess I should not take this any further in th...

jerome_rajan

Craig,

Don't mean to hijack this post but can you please elaborate on

Create a stage variable (you don't need to use it for anything, it keeps the stage happy)

jerome_rajan

Hi, We are trying to develop a generic job that can extract data from a set of fixed width files and load them into a DB2 database. The fixed width files contain a few amount fields that are represented without a decimal point. For e.g. 1000.23 is represented as 100023. The metadata of these files a...

DSXchange

Search found 376 matches

Transformer as Source

Handling Decimals in RCP Job