DSXchange

i'm goint to mark this topic as Resolved, though it actullay isn't. But i've more accurately described the problem in a topic called Java Issues with DataStage.

We upgraded to DS 8.0.1 at our shop back in May. Since then, we have very random job failures where the job runs successfully with no warnings or errors, but then has a return code of 134. Since our job script check that return code and finds a value other than 1, it resets the job , and our process...

I'm hoping someone might have run into this already, though I don't see any postings about it so far. We've been getting very random job failures where no warnings at all appear in the job logs. The only indication of an error occurs in the final few lines of the log, where, after the normal process...

Thanks everyone for your suggestions. I was able to come up with a Basic routine to handle the file. I use a counter as a positional reference to keep track of where I am in the file. It's not really reusable (we have several of this file type and I'll have to customize the routine for each file), b...

Ray - Thanks for your response. I thought it might involve reading each row as a single string. As far as parsing within a transformer, do you have any suggestions how this might be done? I'm having trouble coming up with how I would keep my place in the row, and match that to the file schema. For e...

Wondering if anyone has run into anything similar to this - We need to bring in a new vendor file through ETL. It's basically a fixed length file, with the exception that any empty or null fields have been replaced by a tilde (~) in a one-byte field. So of course a tilde could represent anything fro...

For what it's worth, I think samjumsm's comment regarding the lack of online help refers to topics that were specific to server jobs. We've recently converted to v. 8.0.1, and are still running mostly server jobs. I've found that references to functions used only by server jobs (eReplace for example...

Thanks everyone for the suggestions. It turns out that since this was a named instance of a database, I needed to use a different port number than that which was our default. Once I did that, the connection was made. I'll mark this as Resolved.

Thomas Smith

I'm attempting to import a SQL table defintion through ODBC (something I've done successfully many times in the past), and am receiving the following error: DSR.MetaGeta(GET.TABLES)(SQLConnect('AutoAccount','adpaccount')): BCI Error: SQLSTATE=S1000,CODE=11,[DataStage][SQL Client][ODBC][DataDirect][O...

I've seen several near-similar posts to this, but not this problem exactly. I'm reading in a flat fixed width sequential file to a server job. Most records have the correct length. But a few have an early terminator, which breaks the remainder of the record off into a new, shorter record. By changin...

Sorry about that. I realized I posted this in the wrong forum. I'll repost in the server job forum.

Tom Smith

I've seen several near-similar posts to this, but not this problem exactly. I'm reading in a flat fixed width sequential file to a server job. Most records have the correct length. But a few have an early terminator, which breaks the remainder of the record off into a new, shorter record. By changin...

Craig -

You were correct. The reason the jobs were running correctly is that the base folders and files were installed, but in a slightly different directory path than what I intended. Thanks for your help.

Tom

OK. Sorry that I wasn't clear. By "unix project level directory", I simply meant the path for the new project (the directory where you would normally see the typical DS folders like DS_AUDIT, DS_JOBS, DS_DATATYPES, and files like uvodbc.config, VOC, VOCLIB, etc.). To create the project, I ...

Our company is going through a conversion, and as part of that effort, we've created a new project for our datastage jobs. I first created a dev version of the project with no problems - everything runs as it should. Today I've created the UAT version following the same steps. I've tested a few jobs...