Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: Problem Character Vdf15.1 and DB2 Express C

  1. #1
    Join Date
    May 2016
    Posts
    6

    Exclamation Problem Character Vdf15.1 and DB2 Express C

    Hi, I'm in trouble! I use DB2 Express C V9.7 for Windows, with VDF application 15.1, and on this server in specific of a client the characters are unconfigured. In the DB2 control center appear correctly. Both the DBexplorer and the application are incorrect as shown in the attached images. I tried everything related to DF_Collate.cfg already, swapping, searching in other places on the server and nothing.


    Thanks for any help.
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	db2.PNG 
Views:	65 
Size:	76.4 KB 
ID:	12691   Click image for larger version. 

Name:	dbexplorer.PNG 
Views:	74 
Size:	93.9 KB 
ID:	12692  

  2. #2
    Join Date
    Feb 2009
    Location
    Brazil
    Posts
    3,464

    Default Re: Problem Character Vdf15.1 and DB2 Express C

    how this table was created and populated ?

    does it already existed with previous data, or was it converted from DF-embeeded .dat files to DB2?

    If converted, there is an option if the data should be converted to OEM or ANSI code page.. this information is saved in the .int file related to your table.. You cant change that attribute after table is already populated.

    DF_COllate.cfg has nothing to do with this.. DF_Collate.cfg is only used by .dat tables..
    Samuel Pizarro

  3. #3
    Join Date
    Feb 2009
    Location
    Somewhere in Vermont, USA - unless I'm not
    Posts
    10,133

    Default Re: Problem Character Vdf15.1 and DB2 Express C

    DF_COllate.cfg has nothing to do with this.. DF_Collate.cfg is only used by .dat tables..
    In DF maybe (I can't say for sure), but DataFlex Reports uses it - even for RDS tables - which come from SQL Lite.
    Garret

    What if UFOs are just billionaires from other planets?

  4. #4
    Join Date
    Feb 2009
    Location
    Hengelo, Netherlands
    Posts
    9,711

    Default Re: Problem Character Vdf15.1 and DB2 Express C

    Garret,

    DataFlex Reports does not use df_collate.cfg directly (since v4).

    DataFlex Reports uses the DataFlex Database API for the DataFlex embedded database and this API uses df_collate.cfg.

    The DataFlex Virtual Machine (runtime) uses df_collate.cfg for string compares.
    Regards,
    Data Access Worldwide
    Vincent Oorsprong

  5. #5
    Join Date
    Feb 2009
    Location
    Somewhere in Vermont, USA - unless I'm not
    Posts
    10,133

    Default Re: Problem Character Vdf15.1 and DB2 Express C

    Good to know - thanks Vincent!
    Garret

    What if UFOs are just billionaires from other planets?

  6. #6
    Join Date
    May 2016
    Posts
    6

    Default Re: Problem Character Vdf15.1 and DB2 Express C

    The tables were created with a script (Create Table) by the DB2 command editor. Could not convert .DAT.


    I already tried using the TABLE_CHARACTER_FORMAT ANSI command inside the .INT file and it did not work.


    Any other tip if I can thank you.

  7. #7
    Join Date
    Feb 2009
    Location
    Brazil
    Posts
    3,464

    Default Re: Problem Character Vdf15.1 and DB2 Express C

    How the data was loaded, inserted into the table ?

    Only by VDF/DF app ? I guess not!

    Do you have more tables with this issue, or this is the 1st one using db2 ?

    DF APP and db2 runs on same server? or different?

    What is the codepage for your database ? Provide the output for the following db parameters
    Code:
    $ db2 get db cfg for <DBNAME>
    ...
    
     Database territory                                      = US
     Database code page                                      = 1208
     Database code set                                       = UTF-8
     Database country/region code                            = 1
     Database collating sequence                             = IDENTITY
    Regards
    Samuel Pizarro

  8. #8
    Join Date
    May 2016
    Posts
    6

    Default Re: Problem Character Vdf15.1 and DB2 Express C

    Click image for larger version. 

Name:	db cfg.PNG 
Views:	29 
Size:	247.4 KB 
ID:	12699The data was loaded from a standard database, where it already has some initial load records.

    Through the VDF application the records are wrong.

    Yes, all tables have this same problem.

    The VDF application and DB2 run on the same machine.

  9. #9
    Join Date
    Feb 2009
    Location
    Brazil
    Posts
    3,464

    Default Re: Problem Character Vdf15.1 and DB2 Express C

    The data was loaded from a standard database, where it already has some initial load records.
    Ok original data was in "Standard DF dat tables" ? so OEM !

    How did you load the data ? This is still not clear! You said that the table was not converted from DF utilities, but the table was created on DB2 directly.
    But how you put the data from your .dat files into the DB2 table ?

    1. Used a compiled DF program, to read from DF-dat table, Moved the values to Target DB2 table, ans saveRecord ? If yes, this should NEVER happened.
    2. If not option 1, what and how exacty have you loaded the data ?
    Export DF dat table into .csv/txt files, and imported into DB2 table using DB2 IMPORT utility ?

    3. What else ??
    Samuel Pizarro

  10. #10
    Join Date
    May 2016
    Posts
    6

    Default Re: Problem Character Vdf15.1 and DB2 Express C

    The data was loaded using the INSERT command. Executed directly in the DB2 command editor. I've attached a sample image.Click image for larger version. 

Name:	script menu.jpg 
Views:	49 
Size:	279.5 KB 
ID:	12700

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •