DSXchange

kumar_s wrote:It is the 'Time' datatype which occupies 8Bytes. ...

Hi,

Thanks for your response, i see size of Time data type on DB2 database as 3 and it accepts '12:00:00' this value to update or insert. It just do not accept through Ascential.
Please suggest me.

Sree

Hi,

I know date and datetime is handled through Timestamp as data type and with 19 length.

Can someone tell me how Time can be handled like what data type and length to be considered and if we have to hard code the value like '13:00:00' how is it handled.

Thanks in Advance
Sree

You have to execute the SETFILE command from the Administrator Client. Select the Project and then click command and then execute the statement. You don't need any routine. Hi Kris, I am sorry to disturb you. I was trying to do the following and was not able to run it successfully. a) I created a s...

Sure, write a job to save it to a hashed file. Make the hashed file have a key and this value. Hard code the key to "Something" or whatever you like. Use UtilityHashRead to read this value into a stage variable in a job sequence. You can now use this value as a parameter. All the Utility ...

Hi, I have an issue with Incremental Load where i do not have a date or timestamp. We decided to go with a numeric field which will resolve the issue theoritically but i cannot store the same in an job control record. Is it possible for me to select value from database into a parameter so that i can...

We have 3 Projects created on 7x environment and i am able to compile the jobs in 2 Projects without any problem, but i have problems in compiling and running job(s) in one Project which is leading to "Error writing to RT_CONFIG1". error message.
Can someone throw some light to help me out..

Hi, I am trying to include three Jobs in a Job Sequence and trying to run. They are in the following Order A -> B C I thought that the above will be considered as starting A and C simultaneously and then start B after completion of A. I do not have any problem when running A->B, it is giving the fol...

Hi, I am trying to use a lookup for the following: I wrote BEGIN_DT and END_DT columns from record to a Hash File, now i am trying to use a Date as ACCOUNTING_DT to look into the file to pick up the valid BEGIN_DT and END_DT. I want to use the condition as BEGIN_DT<=ACCOUNTING_DT AND END_DT>=ACCOUNT...

This is a driver message, see IBM Error Messages for details or further reading. The process cannot allocate additional virtual memory. Is this error sporadic or does it happen every time you try it with this job? If it always happens, is it at the same row? Hi, Thanks for the response, do you know...

Hi, My Job is writing all the error data to an error record and while writing the same it is getting the Message using a Lookup. I am getting a warning with the following message "K_FDM84_88_JRNL_LN..lkp_PS_MSG_CAT_ETL_VW: [IBM][CLI Driver] CLI0120E Memory allocation failure. SQLSTATE=HY001&quo...

You are getting the system date successfully, as is obvious from your error message. What you're not doing is handling it correctly. Need more information about what you are doing to provide specific help. What target database, target field, stage used, target datatype, etc. You'll more than likely...

Hi, I am trying to use DSJobStartDate to get the Current Date into Transformer Stage and to pass the same to Database. The system is throwing the following warning. Please suggest how to use the System Date not Datetime. K_FDM84_88_JOBCODE_TBL..k_exp_JOBCODE_TBL: At row 1, link "k_exp_JOBCODE_T...