DSXchange

i updated to teh details of my database in dsenv file..but iam getting the same error.

Iam using API

Hi. I am working on Datastage 7.5 and Db2.As our Server is shifted to a DR location i have installed DS client in a local machine. While iam trying to import the metadata from db2 database into a job, iam getting an error as "unable to connect to DB2" even though the User has enough privil...

Thanks Sai.

Hi All, I want to clear the PH directory as its size is growing huge. When i tried to excute the command CLEAR.FILE&PH& from datastage administrator, i got an output as: Verb "CLEAR.FILE&PH&" is not in your VOC. Can anyone share whats the reason for this and provide me with...

Hi All, I tried to run a script in AIX , But i got an error as invalid arguments, which i have never witnessed before. can some one help me in solving this issue ? my script is as follows, cd /samba/Events_new file=`ls -lrt | grep "INCOIS" | tail -1 | tr -s ' ' | cut -d ' ' -f 9` cp -r ./$...

HI RAY,
Can u get me the solution for this, i was strucked with this.

few more warnings i got are,
Sequential_File_0: When validating import schema: Unrecognized top level format property: time_format="%hh:%nn:%ss"
Transformer_2,1: Conversion error calling conversion routine time_from_string data may have been lost

and iam facing the warning as,
DB2_IND_SOI,0: Invalid time value in getInputFieldAsTime() for field '3' of input dataset '0'.

thanx in advance.

Hi, My target database is DB2, and the fieldtype of the column is TIME of length 8.My sequential file contains time column which has fieldtype of varchar. i used the following type conversion in transformer stage, StringToTime(DSLink3.Obs_tm,"%hh:%nn:%ss"), but i was unable to load the who...

Hi All, I have a sequential file, which has the time field. I was unable to transfer the records which has the time format '0:00:00' i.e the records of 0:00:00 to 9:59:59 were not loading into my target table. My target column has Time field and iam using an transformer stage. can anyone help with t...