Unable to See"Sample Contents" of a Table

[Lou]

I created a small database and defined a simple table with about 12
columns. To load the table I imported data from a text file. I got a
successful message after importing the data; no error messages at all.
However, when I try to get a sample of the database, nothing comes
up. I only the the columns I defined, but no rows at all. What did I
do wrong? I'm using Personal DB2 8.1.

Thanks for your help.

Luis

[Blair Adamache]

Did the import confirm that 10 rows were inserted and committed? i.e.

import from C:\IXF\ADDRESS.IXF of ixf commitcount 20 replace_c

SQL3150N The H record in the PC/IXF file has product "DB2
"20010621", and time "211427".

SQL3050W Conversions on the data will be made between the IXF
"850" and the application code page "1252".

SQL3153N The T record in the PC/IXF file has name "C:\IXF\ADD
qualifier "", and source " ".

SQL3109N The utility is beginning to load data from file
"C:\IXF\ADDRESS.IXF".

SQL3221W ...Begin COMMIT WORK. Input Record Count = "12".

SQL3149N "12" rows were processed from the input file. "12" rows were
successfully inserted into the table. "0" rows were rejected.

Number of rows read = 12
Number of rows skipped = 0
Number of rows inserted = 12

Lou wrote:

I created a small database and defined a simple table with about 12
columns. To load the table I imported data from a text file. I got a
successful message after importing the data; no error messages at all.
However, when I try to get a sample of the database, nothing comes
up. I only the the columns I defined, but no rows at all. What did I
do wrong? I'm using Personal DB2 8.1.

Thanks for your help.

Luis

[Lou]

No, Blair, I didn't see the confirmation of how many rows were
inserted/commited like in your example below. Another thing is that I
imported the data using the options in the Control Center interface.
Maybe I should try it using the "import" command in the Command Window
as in your example, right?

Thanks,

Luis

Blair Adamache <ba*******@2muchspam.yahoo.com> wrote in message news:<bv**********@hanover.torolab.ibm.com>...

Did the import confirm that 10 rows were inserted and committed? i.e.

import from C:\IXF\ADDRESS.IXF of ixf commitcount 20 replace_c

SQL3150N The H record in the PC/IXF file has product "DB2
"20010621", and time "211427".

SQL3050W Conversions on the data will be made between the IXF
"850" and the application code page "1252".

SQL3153N The T record in the PC/IXF file has name "C:\IXF\ADD
qualifier "", and source " ".

SQL3109N The utility is beginning to load data from file
"C:\IXF\ADDRESS.IXF".

SQL3221W ...Begin COMMIT WORK. Input Record Count = "12".

SQL3149N "12" rows were processed from the input file. "12" rows were
successfully inserted into the table. "0" rows were rejected.

Number of rows read = 12
Number of rows skipped = 0
Number of rows inserted = 12

Lou wrote:

I created a small database and defined a simple table with about 12
columns. To load the table I imported data from a text file. I got a
successful message after importing the data; no error messages at all.
However, when I try to get a sample of the database, nothing comes
up. I only the the columns I defined, but no rows at all. What did I
do wrong? I'm using Personal DB2 8.1.

Thanks for your help.

Luis

[Blair Adamache]

You could do that - you also have to identify a message file with the
Control Center. Does the message file show any errors?

Lou wrote:

No, Blair, I didn't see the confirmation of how many rows were
inserted/commited like in your example below. Another thing is that I
imported the data using the options in the Control Center interface.
Maybe I should try it using the "import" command in the Command Window
as in your example, right?

Thanks,

Luis

Blair Adamache <ba*******@2muchspam.yahoo.com> wrote in message news:<bv**********@hanover.torolab.ibm.com>...

Did the import confirm that 10 rows were inserted and committed? i.e.

import from C:\IXF\ADDRESS.IXF of ixf commitcount 20 replace_c

SQL3150N The H record in the PC/IXF file has product "DB2
"20010621", and time "211427".

SQL3050W Conversions on the data will be made between the IXF
"850" and the application code page "1252".

SQL3153N The T record in the PC/IXF file has name "C:\IXF\ADD
qualifier "", and source " ".

SQL3109N The utility is beginning to load data from file
"C:\IXF\ADDRESS.IXF".

SQL3221W ...Begin COMMIT WORK. Input Record Count = "12".

SQL3149N "12" rows were processed from the input file. "12" rows were
successfully inserted into the table. "0" rows were rejected.

Number of rows read = 12
Number of rows skipped = 0
Number of rows inserted = 12

Lou wrote:

I created a small database and defined a simple table with about 12
columns. To load the table I imported data from a text file. I got a
successful message after importing the data; no error messages at all.
However, when I try to get a sample of the database, nothing comes
up. I only the the columns I defined, but no rows at all. What did I
do wrong? I'm using Personal DB2 8.1.

Thanks for your help.

Luis