DSXchange

Just came across this thread yesterday on how to remove non visible characters.

Maybe it will spark some ideas.

viewtopic.php?t=98175

Rob W

We are doing something similar here at our site. Our Universal Copy software takes care of translating from EBCIDIC to ASCII and puts the proper CRLF in the data. We created COBOL copy books to describe the various embedded record types and imported these definitions into the CFF stage. The first th...

The approach I've used in the past is to only insert/update the update date in the main sql. Put an update statement in the 'after' subroutine part of the OCI or ODBC or whatever, setting the insert_date to today's date where the insert date is null. This should only update the row you've just inser...

You have a monitor open in Director. Close the monitor and try to compile your job again in Designer.

pukars4u wrote:Hai I am getting the below error when i am trying to compile a batch job

can anyone help me


cannot get exclusive access to executable job batch: Batch job --Job may be monitored

C'mon, I live in Canada. I'm talking Tim's here, coffee that grows hair on your chest.

I've seen this error when the input key value does not line up with ':1" value in the query, i.e. you are passing the bind variable in the 4th port, but have defined your variable as the first port (:1). Make sure they all line up, better still, ensure your key values are at the top of the list...

...and you know what I discovered! Having 'Charter Member' beside my name plus $1.25 will buy me a small coffee!

I ran into the same issue some time ago. After asking around to a number of colleagues, including an Ascential (IBM) consultant, I still did not have an answer. As my data did not turn out to have any 'other' values, I got away with not having to impliment this logic. Sounds like this is a good feat...

Well, needless to say, I did pay. I can't think of a better resource anywhere (other than Greg Sherry and Peter Paton who sit close to me :D) for DataStage help than Dsxchange. You'd probably gladly pay $50 for a good book on DS and, ultimately, this site provides at least as much utility as a good ...

I paid, I joined. If my $50 helps keep things running and gives me full access to all the top posters replies I'm WAY ahead. I'm not a newbie, in fact I think I'm pretty good. Not in the top group but I get by. $50 is nothing compared to the time I've saved, the answers I've found and the knowledge...

gateleys - I understand gmorey's point of view and actions, but this new system needs some time to be understood correctly before it is condemned. Getting a qualified answer is certainly worth $50 - just compute your hourly wage and see how many minutes of your work that works out to. I think it wi...

gmorey wrote:I've created a poll about the new Premium Content here.

*Admin edit link removed*

Hmmm......

Curiouser and Curiouser.....

In the end, our bug turned out to be a TeraData issue. The developer working on this piece of code loaded the input file into TeraData using a method other than DataStage and observed the same issues. Bug was bumped to NCR support, who determined that TeraData was loading and storing the data correc...

Initially, we were just taking the incoming varchar field and sticking it in a Dec(18,0) field. Later we did some monkeying around with the functions I mentioned above. We'll have a look at the stuff you are suggesting, I think it will generate a couple of new ideas. Thanks for your input, Arnd. Rob W

We are trying to load data into a TeraData Dec(18,0) field using a MultiLoad stage. The source data is formated as text. We perform some deduplication and validation upstream and convert the field in question from varchar( 18 ) to Dec(18,0). When loading into TeraData, any number that is bigger than...