DSXchange

I would like to Thank all of you for your answers and suggestions; however, my Project Manager has decided that too much time and money has been spent on this issue. We will stick with using the VB6 application for the time being. Maybe in the future we can convince the users to change the format of...

Thanks for the information, and I'll see what we can do with it. I appreciate your help.

We are using the OBDC stage. We are able to create the DBF files; however, we do not know how you set it up to create the MDX files. The DBF and MDX files are dBase IV products. The MDX file is a special file that contains multiple index files. Currently, these files are created by a VB6 application...

I looked some more on the forum and found my answer!!!! I did a to_char(batch_dte, 'YYYY-MM-DD') in the SQL to obtain the field, then in the Transformer, I did a DATE.TAG(batch_dte) as the derivation. The date came out in the file as 2007-04-17, instead of 2017-04-07. Thanks to the forum and all its...

I am attempting to write a date, as well as other information, from an Oracle table to a seq file. The field is defined as DATE in the Oracle table and VARCHAR(10) on the seq file. Without any date functions, etc., the date written to the file is the internal date, for example, 17995. When I use the...