DSXchange

Hi, One way to search data in Hash file is to open the Hash file in designer & click on <Find> (As u have DS on Windows). For second one if the source have different length then there may be chances of data truncation. So you can take data from the two sources (one with length 40 & other wit...

Hi,
Try using this
VALUES ( 9999 , 9009 , "2006-08-21 14:30:00.000000").

Hi,
Ray Congratulation. You are really helpfull. Keep posting & helping us.
Thanks,
Bhaskar

Thanks to all of you. I have resolved the problem. Actually view name was very big, thats why this error came. So I just reduce the no of characters from the view name & now its running fine.

Thanks,
Bhaskar

My other jobs, based on similar logic are running fine.

Hi, My job design is as follows, View (source)(DB2) --------> Transformer ----------> Target table (DB2) - Lookup view (DB2) --------------- While running the job I m getting error as "Error retrieving system catalog information for requested tables" "Invalid string or buffer length. ...

This warning ( The syntax of the string representation of a datetime value is incorrect. ) is coming for all the records, though I have checked the data which got inserted in the target table & they are ok. But I think some tuning should be done for view as it tooks very much time to run the que...

Hello Chulett,
Design of job is

Source View---> Transformer ---> Target table

I am using DB2 as target database. I am getting one more warning "The syntax of the string representation of a datetime value is incorrect. SQLSTATE=22007" but I am able to view all the data from view.

Hi,
I am trying to load a table from a view, the view contains 16 lacs record. It runs fine till 13 lacs record but after that I am getting error "Error retrieving results from server." Is this because of number of records? Please help me in resolving this problem.
Thanks,
Bhaskar

Hi

while i m try to aggregate 923000 rows of data , after 910000 rows its gives the warning as "Abnormal termination of stage AGGREGATOR" and job gets the aborted.

Hi chulett,
The OS is AIX. I am not using 'cron' or 'at'. I am just scheduling my job from director for evryday (ex:- to run by 7 am in the morning).

Hi Arnd,
My job runs fine when I run it with dsjob command.

Hi,
Operating System is UNIX, I am scheduling my job (for daily run of job) from director.

Hi,
My Server job runs fine when I run it from director. But once I schedule the job to run in future. It got aborted with message "Failed to allocate environment handle 'ENV'". Can anyone please suggest solution.
Thanks,

ya , job is server job