DSXchange

shivan wrote:I need to find its solution, because the job is in production now.

shivan

If you feel our responses aren't adequate or timely, feel free to call Ascential support.

I feel like I'm talking in circles. If you have 2 rows of different data, all columns different except for your suspicious date column and one row rejects and the other doesn't, then logic dictates that it's not your date column that's the problem. Can you create a single row in a text file and try ...

None of that matters. If the same exact column definitions and derivations are send to CLI plugin and a text file, and the data looks correct in the text file, then the only answer is that the plugin is manipulating the data further. We know this is true because the Informix CLI plugin requires DS i...

Add an extra output link to a sequential text file and look at the data there. What do you see?

Please post your exact derivation.

Welcome. You're trying to use DS to read a list of sp from a file and execute them? Can't do that using the OCI stage. You're doing something very wrong with the tool. The OCI stage is a data streamer, either as input or output. If you have a text file of stored procedures and want to execute them, ...

You're doing an ICONV on the date data, which will give you the internal representation of a date. So, May 15th 1995 is 10000, so you can't possibly be getting more than 5 digits in length. If ICONV gets passed text or non-recognized date formats, it returns BLANK. Therefore, we need to know the dat...

shivan wrote:Substrings(INPUT_TO_TFMR.LVL_DATE,0,10)

Start at character 1, not 0.

Your query can use a WHERE clause with the system date variable appropriate to your database to limit the rows out of the database. This is preferred because then those rows don't have to leave the database, traverse the network, and then be thrown away by DataStage. The option of using a Constraint...

I'll bet a box of donuts your system was slammed running a bunch of jobs. Your job control API failed because DS was unable to open the hash file because either the maximum number of hash files allowed open was exceeded or some other internal issue. Next time this happens, do a "ps -ef |grep phantom...

Continuing for Arnd.... How much data are you going to process? Designing an ETL application for moving thousands of rows of data can be a lot different from a system that moves millions of rows of data a day. What kind of data? From a database to a database? From copy books to flat files? What are ...

Upper limits for 64bits is high terabytes. Limit for 32 bit hash file is 2.2 gigabytes. DS only creates 32bit hash files thru the Designer, you have to use command line create statement to get a 64bit file.

DS has an OCI8 and OCI (which is 9 and 10) stage. If you use OCI8, you have to use Oracle's sqlnet 8 client to have backwards compatibility thru their driver to 7.3 database. You cannot use Oracle's sqlnet 9 client to talk to Oracle 7.3 database. Take it up with Larry Ellison if you need to. You can...

Open DS Manager and write a quick function to test. Your logic would be: Ans = ICONV(Arg1, "D") where Arg1 will contain a test date. Hit your Compile button and then the Test button and try 5/8/2005 as the argument. Hit Run and see if the result looks like a number around 13600. I don't know the exa...

And do what with the result? Write it to another table, a text file, ftp to a mainframe, what? From what database, Oracle, UDB, SQL-Server, using what stage, OCI, ODBC, etc? Do you want user-defined or generated queries? Your request is one of the first things you do in training. If you haven't had ...