DSXchange

Thanks for the quick response Craig. It looks like our current value for EXACTNUMERIC is 15. However, this raises another question - if we modify the value, do we need to re-compile the existing jobs on the server? (I've searched the documentation about this, but can't seem to the relevant entry.) P...

Simple question here, but I can't figure out what's going on... I've defined a column in a transformer stage as DOUBLE with a precision of 20 and a scale of 0. However, when a 19 digit number is passed through this column, it is rounded to the first 15 digits. Any ideas about why this might be? Than...

Thanks guys. I'll try bringing the data in as a string and see what happens.

Cheers,

Peter

We're attempting to define a complex flat file in DataStage, and one of the columns is a Native Type of DECIMAL with a Precision of 19. However, when I attempt to define the CFF in Datastage, a message pops up that states 'Column Length must be from 1 to 18', and I'm prevented from saving the value....

I've tried this out, but it doesn't seem to be working for me. In my example, I have an inbound column named Lnk_From_Src.ExpEval. The column is defined as a varchar and contains numeric expressions that need to be evaluated at run time(i.e. '2+3=4+3', '1+1=2-0'). Within DataStage, I'd like to evalu...

What's really strange is that in the cases where this has happened, production support usually attempts to run the job a second time without a problem. Also, the jobs in question are protected. This has randomly happened to different jobs at the rate of about 1 per week. When executing a job from a ...

When executing a job from a script, the following message code is reported: ERROR: Failed to lock job Status code = -10 DSJE_JOBLOCKED We've looked in Director, and the log doesn't register the related code having run within the last 7 days. In addition, the Cleanup Resources utility does not list t...

I'm seeing something very strange in one of my jobs... My incoming source file contains inserts and possibly multiple updates for each target record in my target table. In other words, the second row in my source file may be an update to the first row from the file which was inserted in the same job...

That's exactly what I was looking for. Thanks! INDEX(yourstring, findthis, occurence) To find the first occurence of "test" in "thislongteststring", use INDEX("thislongteststring", "test", 1) and it returns the character location of the beginning letter, other...

I need to search a string for another string value. For example, in VB scripting there's the instr function that operates as follows: InStr(string1, string2) If string2 is found anywhere in string 1, then the position at which the match is found is returned. If string2 is not found in string1, then ...

Thanks Tony - works perfectly.

I'm executing a job sequencer from a UNIX command line using a scheduling tool. If a job in the sequencer fails, I want the sequencer itself to fail and return a failure code to the scheduling tool.

How can I return a failed status from a job sequencer?

Thanks!

Peter

Wow. Can't believe I missed this one!

Thanks for the help,

Peter

Doesn't a stage variable re-initialize as each record passes through the stage?

Thanks for the feedback. Just to clarify - I would like to pass the values between rows, not between stages. For example, let's say I want to detect whether I've received 5 or more records with a specific value in a given column. Each time I detect that value in the incoming data, I would like to in...