DSXchange

hi friends

this is error message i got in DS log of my Job. can u give me any hint related to this error.

if any other information u want tell me.

thanks

here i m not creating a hash file in disk only using check option "Allow Stage Write Cache". so i think it will not allow more than 128 MB. i got another message "collection aborted [Informix][Informix ODBC Driver][Informix]Could not position within a table (informix.tablename). SQLEx...

hi

Did u check the NLS INSTALLED in ur machine or not.
this is option u have to check while installing the DS

deepak singhal

hi using the SCD job u can create Surrogate key value to coloumn. in this job u have to use a hash file as lookup and same file u will use for update the data. u look up in to hash file based on incomming data from main file or load. just create a stage varibale to generate surrogate key based on id...

hi all my problem is : i m using a informix stage and hash file , i m using query to extract the data from database and load into informix stage and populate a hash file . i m using this hash file a lookup in my other job. i m using a huge table as a input to informix stage. my other job is not work...

hi
Go to the Datastage director and click view it will dropdown menu click show all it will show the entire log generated by job ,


so u can easily delete the log

deepak singhal

hi

if u have created a user name and gave password to the user
so u have to give valid user name and password to the datastage client.

u can'nt omit this,

otherwise u have to remove user from datastage client

deepak

Hi vinod
u can do this seperation by using StageVar in ur transformer and populate these records into other file as u want.


deepak

hello i want to find that why we r using this option "Allow write stage cache" checked in Hash Stage. currently i m using this option as checked. my problem is that i am querying from informix stage and input the large amount of data in to hash file.and use this hash file as a lookup, but ...