DSXchange

Thanks jwiles. It is working now. I did not use the stage variables. I just used the earlier concatenation formula this time enclosing the Ifs and Else in brackets.

How about something a little simpler (and probably more efficient CPU-wise as well), like this: svDay: Convert("abcdefghijklmnopqrstuvwxyz","",Field(COLNAME," ",1)) svDate: svDay : " " : Field(COLNAME," ",2) : " " : Field(COLNAME," &q...

Data string '2011-02' does not match format '%yyyy-%mm-%dd Try using '%yyyy-%mm' instead. ... Hi Ray, Actually I need yyyy-mm-dd. The formula inside StringToDate is just giving yyyy-mm and passing it on to StringToDate as argument The output of the derivation should be 2011-02-23....somehow it is g...

I used the Field Function and did this but now I am facing a rather strange problem. My source column data is like 23rd February 2011 I used the following stage variable. Pasted the derivation below Note that the delimiter in Field is 1 space. StringToDate(Field(COLNAME," ",3):'-':If Field...

My requirement is exactly the same as mentioned by you in point a). That is Simply load the source value (varchar) into the target column (date), converting datatypes in the process The downstream processes can extract the required format using SQL But the issue here is that the source table has all...

I have a column in source DB2 table which is defined as Varchar, It contains Date of Birth in the format '1st January 2011' (without quotes)

My target DB2 table has the same column but data type is Date. I need the above source data in this column in the same format as above..How can I do this ?

Resolved. Query used inside ODBC.

SELECT CAST(COLNAME AS VARCHAR(4000) AS COLNAME FROM TABLENAME

Define Metadata as VARCHAR. Length 4000

The job fails with error " Data type not supported"

I am facing problem with DB2 data type Long Varchar. The column is defined as Long Varchar in DB2. The max length of the contents inside this field is 16000. I fired a query to make sure of this. I am using ODBC Enterprise stage and trying to read this column data in datastage. I have imported meta ...

I have not tried this one..Not sure how to go about that.

I have tried stopping and restarting engine but it did not resolve the issue.

Any ideas? Anyone?

Yes I can..The issue is only in Designer. I can see the Default Folder Tree inside the project...i mean the system folders such as Jobs, Transforms, Routines etc..But I am not able to view the names of sub folders that I create manually inside one of the above mentioned system folders.Neither can I ...

I am not able to view any job names in the repository. I can view the folders and when I expand those, I can view the job Short description but not the job name. DataStage Client is v8.1

I am trying to use DB2 Enterprise stage. The DB2 is setup on remote server, DataStage version is 8.1, DB2 client version is V9.5. Db2 Server version is also 9.5. The job has a DB2 enterprise stage and a Dataset..I am trying to fetch records from a table using Select query and o/p the records to the ...

Data has various record types and it comes as a fixed width flat file. In a specific record type there is a key column. This is the parent..There are other record types which contain the same key and these are the children of the former.