DSXchange

Trying to execute the below SQL from an Oracle Connector stage fails with ORA-00942: table or view does not exist. Yet, it works fine in view data?!?! We strongly suspect NLS mismatch with runtime environment variables. The Oracle 11g DB we're connecting to has NLS Settings, soL LANGUAGE = ENGLISH T...

Hi James, Sorry for delayed response. I was off-site yesterday. Yes, it worked exactly as you suggested. Worryingly well, in fact! ;-) instead of failing to compile after 4 hours and consuming 4 GB of RAM, the errant job now compiles instantly with a max of 1 MB RAM consumption. Many many thanks for...

A fairly simple 3 stage job, read from sequential file, transform, insert to Oracle with Oracle connector stage will not compile. Its a 800 column row. But, still...? The compilation attempt is consuming 3GB of memory, and running for 4 hours, and never successfully compiling. Has anyone encountered...

So for 8.0.1 the only solution would be Arnd's code? @Arnd, do you have access to that Ecase number yet? (so the client can follow-up with IBM)

Hi Arnd, many thanks for the hint. Removing the project level auto purge setting has made the problem go away. Is this a known bug? (by anyone except you) Is there a fix? Does Fix pack 2 for v8 help? Is there a workaround available? e.g. script/routine for clearing logs "manually"? I've re...

We are encountering random aborts of multi-instance server jobs . i.e. a different instance of different server jobs aborts with "Missing Parameters" In this example there 8 concurrently executing instances of the same sequence/jobs, but only 1 instance fails with the "Missing Paramet...

Sadly, the WRITEBLK seems to have no effect. Here the Routine Code (can someone spot a foolish error?): vFilePath = FilePath vFileName = FileName Ans = Ebcdic(FileContent) *Content of the file seqFile = vFilePath:'/':vFileName OPENSEQ seqFile TO FILE THEN NOBUF FILE ELSE CREATE FILE THEN NOBUF FILE ...

sorry for the false posting - I know better now.

But, Just to close, yes there was a Job 21. And, the log was not open anywhere.

It's only a small project in Dev, so I resolved it by deleting and recreating the project.

CLEAR.FILE RT_LOG21 executed in administrator commands returns "Unable to Clear File RT_LOG21" "filename = " Can I delete the log folder from the unix file system? Will this force DataStage to recreate the log? Or will it increase the corruption?

Hi Craig,

In testing, this:

Ans = Ebcdic(FileContent)

does work without any DEFFUN

(I was confused by the WRITESEQ problem that Ray explained in the other post, as I didn't get my EBCIDIC.)

Many thanks to all for the replies. I like Ray's idea best . I really don't want the o/s to have to tidy up something that datastage can't do. I'm not back on that site for a few days, but I'll update again after I've tested it.

e.g. is there an OPENBIN (or similiar)

how could the below be converted to write an EBCIDIC file?

OPENSEQ seqFile TO FILE THEN NOBUF FILE
ELSE CREATE FILE THEN NOBUF FILE
ELSE STOP
WRITESEQF Ans TO FILE

e.g. Ans = Ebcdic(FileContent)

to convert ascii Filecontent to Ebcdic code set

Hi Arnd, I'm sorry, but I don't know what you mean with "but use the DataStage BASIC ASCII or EBCDIC functions"

When I View Data in the Stage I already get the hex values in the viewer grid.

Where or how could I apply a transform/routine to the troublesome BLOB column?

do all columns in the table (hashed file) need to be addressed in the update statement?