DSXchange

Thanks all it worked out!!
as per Craig and Chowdary advice..

Hi Heather,
where do i get DateIconv ? is it a routine?

Thanks

How to convert input MM/DD/YY date value (char) to CCYY-MM-DD (Date type) of target table.

I am using but it is not converting.

Any help appriciated!

Hi Craig, I should have mentioned Numeric fiele as target table. I did not get DIGIT transform as mentioned in your earlier reply, would you please explain it. Here is what i am trying to do. I have Char field with value 195,231 and in some of the as 21- (negative value), what is the best way to mov...

Craig,

I tried moving 195,231 (char value) to Numberic value of DB2 table,it did not get moved as 195231, it is moved as 0.

Thanks

but in my input data Coma (,) is part of data. !

Hi,

Can any one pls provide Format function for following example
I need to format 195,231 char to 195231 numeric.
Any help is appreciated!

Thanks

Hi Kim,

thanks for valuable information. Could you please tell me how to create Q pointers.

Thanks

hi Kim, Following Select statement got from the link you provided select EVAL DS_JOBOBJECTS."@RECORD<6>" AS FILE_NAME FMT '35L', DS_JOBS.NAME AS JOB_NAME FMT '35L', DS_JOBOBJECTS.NAME AS LINK_NAME FMT '35L' from DS_JOBOBJECTS, DS_JOBS where DS_JOBOBJECTS.OLETYPE in ('CHashedOutput','CHashe...

Let me try the tool But is there a way with out using the tool.
I think there should be some SQL to fetch the jobs using a Hashed files. I tried searching in the forum could not find it.
~

Can anyone tell me how to check a particular Hashed file being used by other jobs in a project.

Thanks

Deepa,
Can i edit uvodbc.config file directly in Unix or do i need to use DS Administrator.

Thanks

add WITH NONE; and the end of the SQL statement

Need help to add an entry to existing uvodbc.config file for my project.
Can any one help and guide me out the process.

Thanks

I am getting following error while loading the data using DB2/UDB Load stage
"Transformer_9: Pin 4 not initialized"

Any help!!!
~