Topic
3 replies Latest Post - ‏2013-02-08T13:40:45Z by SystemAdmin
SystemAdmin
SystemAdmin
5837 Posts
ACCEPTED ANSWER

Pinned topic db2express-c & AS400

‏2013-02-08T10:41:18Z |
Bom dia !
Estou tentando importar um script que foi gerado em um DB2 em AS400 para um DB2Espress-C para windows e está apresentando alguns erros.

Alguém saberia me dizer se existe alguma imcompatibilidade de comandos entre as duas plataformas?

Por Exemplo:
O script que está vindo do AS400 tem as seguintes linhas:
IN HSFTBSPACE_08
INDEX IN HSFTBSPACE_I08;

E quando fui rodar o script no DB2Express-C windows deu erro, falando que o Nome HSFTBSPACE_08 não foi definido.

Agradeço a ajuda de todos.
Updated on 2013-02-08T13:40:45Z at 2013-02-08T13:40:45Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    5837 Posts
    ACCEPTED ANSWER

    Re: db2express-c & AS400

    ‏2013-02-08T10:55:01Z  in response to SystemAdmin
    Good morning!
    I'm trying to import a script that was generated in a DB2 AS400 to a DB2Espress-C for windows and is showing some errors.

    Someone could tell me if there is any incompatibility of commands between the two platforms?

    For Example:
    The script that is coming from AS400 has the following lines:
    IN HSFTBSPACE_08
    INDEX IN HSFTBSPACE_I08;

    And when I run the script in the C-DB2Express windows gave error, saying that the name HSFTBSPACE_08 not been set.

    I appreciate everyone's help.
    • SystemAdmin
      SystemAdmin
      5837 Posts
      ACCEPTED ANSWER

      Re: db2express-c & AS400

      ‏2013-02-08T13:30:05Z  in response to SystemAdmin
      It seems that is a create table statement.

      Are you sure that these tablespaces are created?

      db2 list tablespaces

      What is the SQL code you are recibing when executing the code?
      • SystemAdmin
        SystemAdmin
        5837 Posts
        ACCEPTED ANSWER

        Re: db2express-c & AS400

        ‏2013-02-08T13:40:45Z  in response to SystemAdmin
        Bom dia Andres!

        Então eu comentei esta duas linhas e consegui importar o código.