DSXchange

Roy - I'm going for the fast-food high volume posting approach; I'll leave the real quality to Roy's and Ray's (play on words to one of my favorite international food chains, and my favorite bartender [but another Ray] ).

Craig - I had to say that about the warnings (if I hadn't I'm sure Ray would have put it in somewhat stronger words when he logs in later). The overhead to write the warnings in that job is going to be far higher than that of the job itself. I've had warning that I was sure I couldn't get rid of - u...

eoyylo, You could set the warnings to 0 but.... For each warning an entry is written to the log file. For that large a number of warnings you are going to get a job performance that is probably about as fast typing the data into the database by hand (well, maybe not quite that bad, but close enough)...

Palmeal - Your substrings depending on everything having a fixed length & position, so your parsing returned odd values when that was not the case. I can just say "been there, done that" Nice is just fine right now - this weekend was awesome and the beaches in Cannes and Antibes are full {of att...

Palmeal, You should use a different function for your substring, that is where your error is originating. The output of field 1 is in the form ""14170\2005-05-30 09:39:44\5\\21\Starting Job JdDSSJOBCheckJobControl. (...)"." (note that when I try it I get a 5 digit message number) To parse the String...

sushanth,

the XML packages need to be installed explicitly, they are not installed as part of the DS default installation. See the installation guide for DataStage and also that for XML for details on how to perform this (quick) install.

snassimr,

I'm not at a DS machine right now, but your TIME() function is, I think, returning Milliseconds so your time oconv might not be working as expected. If you redirect your output to a sequential file instead of the SQL server table, what does derivation write to the file?

Please show which statement you used and someone here will assist you, but just stating "it didn't work" won't help towards solving the problem.

dslearner, if you can put your logic in stage variables it tends to be a bit faster than by incurring the overhead of calling a routine (which involves pushing the current program on the stack, calling a new routine, and popping back to the caller). As Wolfgang explained, there are many cases where ...

Shyju_010,

I hope this answer is detailed enough for your expectations. When you enter the "Use Account Name" you specify the DataStage project name. You most likely had a spelling error.

chulett wrote:Hope they get the job, Arnd.

Naah, they won't

DataStage doesn't have an image stage, it would just take this data (as a binary datatype) and pass it through to wherever you wish to send it. If you know the format of your image files, or if each entry in the "image" column is it's own file, then you could use DataStage to do this.

Johm73, If you redirect your output to a sequential file, and add an output column that has the result of NUM(YourNumberColumn) does it show numeric (i.e. a value of 1)? If it shows 0 then look at your number field (do you need to do a TRIM() on the string to get rid of spaces? Does it contain a dec...

Johm73, If you are doing a string to integer conversion, the function NUM(YourString) will return a 1 if it is numeric, a 0 if it is not. You can use either the FMT() or the OCONV() function to expictly format your output. What is your target Oracle datatype? If your insert is failing on each row, h...

Hello Johm73, the good news about DS Server is that it is essentially typeless. If you have a varchar column and you add 1 to, the engine will perform a conversion. This is good if the column actually contains a number but causes conversion issues if it isn't. There are a number of function and conv...