DSXchange

Thanks allot, It works well .

I tried it earlier, but problem with formatting data into DD/MM/YYYY only.

After saw you reply I thought to ensure the formatted data and I found while ensuring I had done wrongly.

Hi All, I am trying to convert string values to date, but the job is being failed to convert string to date when I was trying with Iconv function with the same string format. I changed the structure to DD/MM/YYYY then I used Iconv(StrCol,"D/E") still it is being failed. Anyone can suggest ...

Hi, I want to populate values into a DB2 database column which datatype is timestamp. Input values are coming as follows 200602111743(YYYYMMDDHHMI). I am moving directly without any transformation logic. It isn't allowed to populate values into database. What transformation logic should I have to us...

It seems every one is keen in posting a solution. I like this approach from this site. I never got quick solution from any other forum other than this. Keep it up dsxchangers.... Thanks everyone .. The solution from Amruta is working in my case Oconv(@DATE,"DY") : Oconv(@DATE,"DM[2]&q...

Hi Vidya, Thanks for ur response. I couldn't find any help on DCode function. Do u mean Iconv and Oconv or DCode is an independent one. By using following expression I get YYYYMM format Oconv(Iconv(@YEAR,"DY[2]"),"DY[4]") : Oconv(Iconv(@MONTH,"DM[2]"),"DM[2]")...

Hi, I am using @DATE function to populate current date value. When I was viewing DSDB2 column values using datastage after population, it shows values as 13914 (2006-02-03). In DB2 it shows in specific format 02/03/2006. Why it is showing same value in two different ways? How will I extract year and...

Thanks for your reply, I tried that way. I want to know more about usage of staging variables! Can't we achieve such loops by using staging variables?

Thanks once again

Lets assume my source file is Dummy.txt which contains only one row and column. MY expected output should contain a single column and 100 rows.
Source
-------
X
Target
------
1
2
3
.
.
.
100
How can we get such values by using server job?

Hi All,

I want to populate a table with single column which should contain values from 1 to 100. I can use dummy source file as follows...
Dummy
---------
X

Thanks in advance

Arnd, Only last column isn't fixed width remaining all are fixed only. I have a requirement to consider it as fixed width. It was solved by using excel workbook. I imported srcfile into excel and saved it as delimiter. Later I took source as csv and achieved what I require. Thanks. I would welcome a...

Thnaks for your reply. I know its not fixed width, How can we overcome such issues by using data stage. Can you tell me in detailed manner.

Hi All, I am working with datastage version 7.0. I am facing a problem to read data from fixed width files using sequential file stage. I am giving you my input file as follows.. Col1 Col2 Col3 100 ABC 213 101 DEF 12345 102 GHI 432 Please notify that my first row terminates after 213. There is no sp...