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

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

    Re: db2express-c & AS400

    ‏2013-02-08T10:55:01Z  
    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

    Re: db2express-c & AS400

    ‏2013-02-08T13:30:05Z  
    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.
    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

    Re: db2express-c & AS400

    ‏2013-02-08T13:40:45Z  
    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?
    Bom dia Andres!

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