DSXchange

I'm confused. Are you writing a Server routine, or PX? You've posted in the PX forum, listed Windows as your OS, but named Server.

Please clarify.

Hey, come on now, you should know asking for URGENT response really angers us . If you're paying for URGENT, then we'll respond URGENT. If you want URGENT, then spend 5 minutes searching the forum. Here's a shell script for starting DS jobs posted years ago. m You can spend another 5 minutes reading...

Yeah, well, you've now got a "." in your data. So your issue is high characters, maybe not necessarily a CR/LF, maybe a TAB. You're going to need to write a routine to strip all non-printables and change them to something you desire. If you just want them removed, the CONVERT statement can serve you...

For giggles, put an OCONV(inlink.col, "MCP") derivation on your problematic column to convert all non-printable characters to a ".". That will make sure your issue is not any high-character. Does that change the problem row?

Never been able to do it. If it's extensive test data you've setup, you could always try to get it out via the .dsx file. If that's not good enough, you can take a stab at writing some DS BASIC and getting the test data out of the DS_ROUTINES internal file.

And that folks, is why we don't do urgent.

staodsSapCONTRAINFLoadUpd..xfmUpdate: [IBM][CLI Driver][DB2] SQL0973N Not enough storage is available in the "DRDA_HEAP_SZ" heap to process the statement. SQLSTATE=57011 This is an error message from the CLI Driver, indicating that there's no heap space available in the database. Seems like a datab...

You can always use the CONVERT statement, which is rather cool. It takes a string of characters and changes the each value to a correlated value in another string. Example: CONVERT "ABC" TO "123" IN yourstring This would change all occurrences of "A" to a "1", "B" to a "2", and "...

After a nice stroll down memory lane, I didn't find anything back in the early days, plus I check notes from customers I serviced back in the late 90's early 2000 to see if I had anything. The only idea that comes to mind depends on your database and your database skills. If you were on Oracle, I'd ...

Thinking back 5 years, I don't remember the ODBC import wizard having the filter on it. It's there under 7.5, but I can't verify from 5.0. The only other method could be under user based permissions on the DB side, but that's kind of messy. Have you searched the forum? The Oliver posts go back a lon...

I read thru the pdf manuals and didn't see anything. This sounds like a bug, because the metadata for the OCI stage link stores this setting, the shared container should have nothing to do with it. If you want to confirm this, explode the shared container in a copy of the job and see if you are now ...

The DS BASIC manual available under your Start button is a great place to learn about the functions at your disposal. Removing characters is easy, lookup up CHANGE or EREPLACE or CONVERT to designate characters for removal. To mass-replace unprintable characters (the very high and low range of ASCII...

Can you tnsping the Oracle instance from your DS server? Is Oracle local to your machine? Did you try to import metadata using DS Manager? Did it connect using the sid, userid, and password? When you setup the OCI stage, are your DB Options set correctly? How about Remote Server, did you add it and ...

Does that mean that you cannot have more than one user defined sql in datastage I don't believe so. That's what the before/after SQL tabs do on the OCI stages. The SQL statement is not a script, it's a prepared statement like a cursor, which accepts streaming tabular data. Now, I could be wrong, bu...

I created a test function with two arguments, put this in it: DEFFUN ConvertMonth(a,b) CALLING 'DSX.CONVERT.MONTH' Ans = ConvertMonth(Arg1,Arg2) I ran the Test button, for Arg1 entered 2005-07 and for Arg2 put an L. I hit Run and got the answer 13727. Give it a try.