DSXchange

chulett wrote:You might want to try using the LETTERS transform that is available under the Built-in/String category. Handles the syntax for you.

LETTERS Transform would stip off the numeric characters too.

Try either of these depending on if your taget column is nullable or not.

If DSLink4.Field002 = "NULL" or IsNull(DSLink4.Field002 ) then @null else DSLink4.Field002.

If DSLink4.Field002 = "NULL" or IsNull(DSLink4.Field002 ) then 0 else DSLink4.Field002

king999 wrote:hi
i have tried using

If DSLink4.Field002 = "null" then IsNull(DSLink4.Field002 ) else DSLink4.Field002

and it worked

it might have worked for you, because you might never had 'null' in input file, otherwise the same error mght have appeared.

dprasanth wrote:

king999 wrote:hi
i have tried using

If DSLink4.Field002 = "null" then IsNull(DSLink4.Field002 ) else DSLink4.Field002

and it worked

The IsNull() would return a boolean value. it does not convert the input field to null.

I am having a problem with sequencer. when i am running the sequencer it gives a warning Controller problem: Error calling DSRunJob(ScrubClm.), code=-2 [Job is not in the right state (compiled and not running)] now even though the job sequencer is calling has been compiled and has worked properly p...

Did you compile the sequence ?

Hello, I am facing a typical problem. I have never faced this before. I have a Sequencer which intern has multiple sequensers inside it with proper dependencies. Let's say My parent Sequenser is PS and the child sequencers embeded in it are S1, S2, S3, S4, S5. Now the dependency is as below: S1->S2...

In a reference lookup the values for where clause are supplied only at run time, so I guess there is no way of viewing the data .
If you still want to view the data probably you can hard code the values that go into the where clause and try viewing it.

While it's true that the Join stage can have more than two input links, they do require a common key, as track_star has pointed out. . Hi ray.wurlod, is there any specific reason why this facility is not provided in join stage. because right now in my work, i frequently encounter this situation of ...

How about accomplishing this at the database level, like using a sequence generator. Does this have any disadvantages compared to the one generated by the Datastage.

Hi, I need to merge 2 files together that have the same composite key structure. I am using a Join stage with the Full Outer join option. Works well when the key instance only exist in only one of the files but when the key instance is present in both the ouput file... Thanks Can you please explain...

Hi, I am trying to read a sequential file and updating a Oracle database using OCI stage. The sequential file has null values in a field1 which is hardcoded as NULL. I am uploading this data to oracle which is a NUMBER field. I tried to define the NULLABLE field as NULL in the sequential file stage...

HI, I am getting follwoing error while running my PX job in DS "Lookup_192,1: Failed a keylookup for record." "Operator's runLocally() failed" Here is what I have, --raj Try "continue" option if the look-up failed and handle it later-on (probably flag the record as err...

I had changed the name for each instance of the job, But we are having another job (reusable job) which is called from a routine. we are calling it as DSAttachJob("<reusable job>", DSJ.ERRFATAL), whether this will create two instances, if it is called in two jobs at the same time or it wi...

My understanding of split level is to add more space once the current space reaches the percent of the 'split load'. Thanks :? I guess Split doesn't mean to add more space, split means when a bucket reaches its threshold level, it splits into two distributing the data between the buckets, instead o...