DSXchange

Is that 'date' internal to AS400? How do you know the value of 12965 is 2003-06-30? If this is how it is stored in DB2 then you need to get it out of there in the format you want. I know that on Sybase IQ, we need to import a DATE column as CHAR/VARCHAR otherwise the date comes in completely wrong. ...

--- whats this? allocating space? excuse my ignorance, but what space are you allocating?

Hallo vbeeram The best way to handel a record that changes slowly over time is to use the checksum function - its much better than doing an AND..OR statement that is tedious to type and difficult to manage. From Help: This example uses the Checksum function to return a number that is a cyclic redund...

We ran into something similar before, and we realised we had not set the kernel parameters correctly for the server.

Did you check your kernel settings?

check /etc/system for the settings. The kernel parameters are explained in the install and upgrade guide.

hallo RStone

this page


http://publib.boulder.ibm.com/infocente ... 002003.htm

explains the command to reset a QuIeScE StAte

A quick search on the internet and I get this: Explanation: All available memory for this heap has been used. The statement cannot be processed. User Response: Terminate the application on receipt of this message (SQLCODE). Increase the configuration parameter for "<heap-name>" to increase...

Hallo Balachandra

use the Iconv function to convert the timestamp into an internal format, then add the 7 hours and then oconv the internal number to a timestamp again. (the help documents iconv/oconv quite well)

dnzl

I am not aware of a cascading function like that, but you could do one of two things (what I would do): 1. save the new table definition and load the new definition where appropriate or 2. when you read from the database, convert the datatype to what you have it as - provided this doesnt interfere w...

Hallo Neo I have the DB link as my stream input and the hash files as reference to the transformer. This is my code for your first column derivation: if ( HASH1.NOTFOUND and HASH2.NOTFOUND ) then HASH3.colA else if HASH1.NOTFOUND then HASH2.colA else HASH1.colA it might spark some brilliance on your...

I agree - to add: we have a situation with IQ bulk loads where we dont get the system return code from executing an 'Auto' load on the stage, which as you can imagine doesnt inform us whether the load was succesful or not. We then moved to BASIC code to handle the execute of the .sql (using 'manual'...

Can you give a little more info on the problem?

Can you not read the output at the end? What is the translate step - a transformer?

dnzl

hi besco I match a sequential File with ORAOCI8 in a transformer. I do a request in ORAOCI8 to get all emails in a table. The problem is : this request takes about one hour to finish. How about putting the data you are comparing with from the ORACI8 data into a HASH stage before the transform stage,...

Thanks guys

ALLOWNFS in uvconfig was set up right.

mapped drives must be mapped using the same username that you log into DataStage with

this solved the issue.

dnzl

I just checked if there are routines to help with this and it looks like you're going to have to use the MONTH.TAG with the Routine ConvertMonth (find it in Manager -> Routines -> Examples )

let us know if you got it!

dnzl

You could write the input into a HASH stage and make the columns key columns, that will get rid of the duplicate records.

dnzl