squirrel-sql-users — A subscriber only discussion list for SQuirreL

Re: [Squirrel-sql-users] Error code message question

[Robert M. <rob...@gm...>]

On 12/7/06, Savoy, Melinda <Mel...@te...> wrote:
>
>
>
> I am running a SQL script to drop tables then create tables and finally
> populate tables.
>
> The last two lines while running the script state:
>
> Query 495 of 495 elapsed time (seconds) - Total: 0, SQL query:0, Building
> output: 0
> Error: localhost: java.lang.ArrayIndexOutOfBoundsException:
> 9 > 5
>
> I guess I don't understand what this is telling me exactly.
>

That looks like it could be a bug in our SQL execution code.  Can you
take a look in your squirrel-sql.log file for the word "Exception",
and if any exist send them to me or file a bug report with the
relevant log content here:

http://sourceforge.net/tracker/?atid=393414&group_id=28383

Rob

Re: [Squirrel-sql-users] can not see Japanese chars

[<Jit...@sp...>]

Thank you soooooooooooo much Nathan !

It worked.

Warmest Regards,
JT






Nathan Aaron <na...@gl...>
12/07/2006 01:33 PM
 
        To:     Jit...@sp...
        cc:     squ...@li...
        Subject:        Re: [Squirrel-sql-users] can not see Japanese 
chars


Try this:

1.      place a copy of arialuni.ttf in the jre home lib/fonts directory
2.      shutdown SQuirreL SQL Client if it is running and restart it
3.      open the Global Preferences window and click the fonts tab
4.      enable Other fonts and choose Arial Unicode MS, 12 for the font

Nathan

Jit...@sp... wrote: 
Hi,

I have Squirrel SQL installed on Windows XP Professional using JDK1.5.2_04 

with Oracle JDBC thin driver for Oracle 9i. Everything works great, 
however, I am unable to see Japanese characters in the Objects->Table 
view. Also, when I paste Japanese characters to SQL window as part of SQL, 

it appears as square chars. Surprisingly, it works fine on my colleague's 
computer.

Any help will be greatly appreciated.

Warmest Regards,
JT



-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share 
your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Squirrel-sql-users mailing list
Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users


 

Re: [Squirrel-sql-users] can not see Japanese chars

[Nathan A. <na...@gl...>]

Try this:

   1. place a copy of arialuni.ttf in the jre home lib/fonts directory
   2. shutdown SQuirreL SQL Client if it is running and restart it
   3. open the Global Preferences window and click the fonts tab
   4. enable Other fonts and choose Arial Unicode MS, 12 for the font


Nathan

Jit...@sp... wrote:
> Hi,
>
> I have Squirrel SQL installed on Windows XP Professional using JDK1.5.2_04 
> with Oracle JDBC thin driver for Oracle 9i. Everything works great, 
> however, I am unable to see Japanese characters in the Objects->Table 
> view. Also, when I paste Japanese characters to SQL window as part of SQL, 
> it appears as square chars. Surprisingly, it works fine on my colleague's 
> computer.
>
> Any help will be greatly appreciated.
>
> Warmest Regards,
> JT
>
>
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
>
>   

[Squirrel-sql-users] can not see Japanese chars

[<Jit...@sp...>]

Hi,

I have Squirrel SQL installed on Windows XP Professional using JDK1.5.2_04 
with Oracle JDBC thin driver for Oracle 9i. Everything works great, 
however, I am unable to see Japanese characters in the Objects->Table 
view. Also, when I paste Japanese characters to SQL window as part of SQL, 
it appears as square chars. Surprisingly, it works fine on my colleague's 
computer.

Any help will be greatly appreciated.

Warmest Regards,
JT

[Squirrel-sql-users] can not see Japanese chars

[<Jit...@sp...>]

Hi,

I have Squirrel SQL installed on Windows XP Professional using JDK1.5.2_04 
with Oracle JDBC thin driver for Oracle 9i. Everything works great, 
however, I am unable to see Japanese characters in the Objects->Table 
view. Also, when I paste Japanese characters to SQL window as part of SQL, 
it appears as square chars. Surprisingly, it works fine on my colleague's 
computer.

Warmest Regards,
JT

[Squirrel-sql-users] Error code message question

[Savoy, M. <Mel...@te...>]

I am running a SQL script to drop tables then create tables and finally
populate tables.

The last two lines while running the script state:

Query 495 of 495 elapsed time (seconds) - Total: 0, SQL query:0,
Building output: 0
Error: localhost: java.lang.ArrayIndexOutOfBoundsException: 9 > 5

I guess I don't understand what this is telling me exactly.

Any help or direction would be greatly appreciated.

Thanks.



Melinda Savoy
Sr. Programmer Analyst
Financial Applications - Enterprise Systems



The information contained in this message and any attachments is intended=
 only for the use of the individual or entity to which it is addressed, a=
nd may contain information that is PRIVILEGED, CONFIDENTIAL, and exempt f=
rom disclosure under applicable law.  If you are not the intended recipie=
nt, you are prohibited from copying, distributing, or using the informati=
on.  Please contact the sender immediately by return e-mail and delete th=
e original message from your system.

[Squirrel-sql-users] Need help to configure oracle database

[Sunitha R. <SRa...@sa...>]

How will I configure oracle database in sql squirrel. Do I need oracle =
pluggin?

[Squirrel-sql-users] Oracle problems

[LeO W. <le...@gm...>]

Hi,

Squirrels seems to have problems with Oracle. I do not know how to figure out, when it fails, but it fails definitely. 

The problem is, that from time to time I am unable to browse any longer through the Objects nor can I open the right-hand side. The content-assist is also broken, i.e. Tables are not offered any longer.

I am not sure, when the problem start to get a problem, but sometimes. I guess it has to do, that I want to click on the Table-content, the content is not retrieved yet, click on the Row-Count, this is also not retrieved yet, I click on the SQL-sheet and start typing.

Any ideas, if my guess is right?

Is there a fix possible? I mean not on my nervous End-user side, cause waiting approx. 200 secs. to get a result, before I can click on the next Tab is a pain in the a** - As well I am aware the DB-performance is lousy, and the approx. 400.000 entries should NOT be THAT big problem for the View.

:)

LeO

-- 
Der GMX SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen! 
Ideal für Modem und ISDN: http://www.gmx.net/de/go/smartsurfer

Re: [Squirrel-sql-users] Just getting started

[Robert M. <rob...@gm...>]

On 12/5/06, Bill Slack <ws...@sh...> wrote:
> Rob thanks for your response.
>
> When I first got Squirrel up and running, I assumed Squirrel started the
> database for me.  I guess I thought wrong: I must have had Netbeans start
> the database and  both were running when I first started Squirrel.
>
> The assumption was reinforced by the fact that I hadn't noticed a mechanism
> for Squirrel to start the database, because it doesn't have one -- as far as
> I have seen so far.  Is that right?  If this is a dumb question, remember
> I'm new to this :-).
>
I believe, it depends on the jdbc url that you use.  Some forms
specify a file path to the actual database files, and in that mode,
the database is running "in-memory" or "embedded".  Usually, only one
JVM can access the database files at a time in this mode.  The
exception to this is the "Network Server" mode which has a JVM listen
for requests on a port, allowing connections from multiple other JVMs.
 It, however, must be the only JVM that accesses the database files
"in-memory".  Here is a nice write-up contributed by Susan Cline on
the Apache Derby website, that talks about using SQuirreL with Derby:

http://db.apache.org/derby/integrate/SQuirreL_Derby.html

Rob

Re: [Squirrel-sql-users] MySql

[Colin B. <co...@ba...>]

On Tue, Dec 05, 2006 at 05:14:33PM -0500, Robert Manning wrote:

> I was going to run the script when I got home, but you beat me to it!
> Thanks - I figured it would work flawlessly.  Thanks for saving me the
> time.

No worries - I was bored.

Melinda, back to the original problem. Is it possible the first time
you ran the script that the tables didn't exist and so the DROPs
failed and then the script stopped. If this is the problem you can
turn off the "Abort on error" option on the SQL tab in session
properties.

-- 
Colin Bell

Re: [Squirrel-sql-users] MySql

[Robert M. <rob...@gm...>]

On 12/5/06, Colin Bell <co...@ba...> wrote:
> The attached script works for me:

Colin,

I was going to run the script when I got home, but you beat me to it!
Thanks - I figured it would work flawlessly.  Thanks for saving me the
time.

Rob

Re: [Squirrel-sql-users] MySql

[Savoy, M. <Mel...@te...>]

Colin,

Thanks for the reply and your time. =20

I will keep trying on my end and see if I can find what/where my problem
is.

Regards.

=20

-----Original Message-----
From: squ...@li...
[mailto:squ...@li...] On Behalf Of
Colin Bell
Sent: Tuesday, December 05, 2006 3:18 PM
To: squ...@li...
Subject: Re: [Squirrel-sql-users] MySql

On Tue, Dec 05, 2006 at 06:52:41AM -0600, Savoy, Melinda wrote:
> Robert,
>=20
> Thanks for the response.  I tried what you suggested however, this is=20
> what is happening.  I have a .sql script whereby I drop tables, create

> tables and then insert data into multiple schemas.
>=20
> It would appear that after I run the entire script the DROP tables=20
> runs successfully but I do not see that any of the tables have been=20
> created and consequently no data has been inserted.  I have to run the

> CREATE and INSERT separately.

The attached script works for me:

0 Row(s) Updated
Query 1 of 28 elapsed time (seconds) - Total: 0.001, SQL query: 0.001,
Building output: 0 0 Row(s) Updated Query 2 of 28 elapsed time (seconds)
- Total: 0.001, SQL query: 0.001, Building output: 0 0 Row(s) Updated
Query 3 of 28 elapsed time (seconds) - Total: 0.001, SQL query: 0.001,
Building output: 0 0 Row(s) Updated Query 4 of 28 elapsed time (seconds)
- Total: 0.001, SQL query: 0.001, Building output: 0 0 Row(s) Updated
Query 5 of 28 elapsed time (seconds) - Total: 0.001, SQL query: 0.001,
Building output: 0 0 Row(s) Updated Query 6 of 28 elapsed time (seconds)
- Total: 0.003, SQL query: 0.003, Building output: 0 0 Row(s) Updated
Query 7 of 28 elapsed time (seconds) - Total: 0.034, SQL query: 0.034,
Building output: 0 0 Row(s) Updated Query 8 of 28 elapsed time (seconds)
- Total: 0.002, SQL query: 0.002, Building output: 0 0 Row(s) Updated
Query 9 of 28 elapsed time (seconds) - Total: 0.049, SQL query: 0.049,
Building output: 0
1 Row(s) Updated
Query 10 of 28 elapsed time (seconds) - Total: 0.001, SQL query:
0.001, Building output: 0
1 Row(s) Updated
Query 11 of 28 elapsed time (seconds) - Total: 0.002, SQL query:
0.002, Building output: 0
1 Row(s) Updated
Query 12 of 28 elapsed time (seconds) - Total: 0.001, SQL query:
0.001, Building output: 0
1 Row(s) Updated
Query 13 of 28 elapsed time (seconds) - Total: 0.002, SQL query:
0.002, Building output: 0
1 Row(s) Updated
Query 14 of 28 elapsed time (seconds) - Total: 0.001, SQL query:
0.001, Building output: 0
1 Row(s) Updated
Query 15 of 28 elapsed time (seconds) - Total: 0.001, SQL query:
0.001, Building output: 0
1 Row(s) Updated
Query 16 of 28 elapsed time (seconds) - Total: 0.001, SQL query:
0.001, Building output: 0
1 Row(s) Updated
Query 17 of 28 elapsed time (seconds) - Total: 0, SQL query: 0, Building
output: 0
1 Row(s) Inserted
Query 18 of 28 elapsed time (seconds) - Total: 0.001, SQL query:
0.001, Building output: 0
1 Row(s) Inserted
Query 19 of 28 elapsed time (seconds) - Total: 0.001, SQL query:
0.001, Building output: 0
1 Row(s) Inserted
Query 20 of 28 elapsed time (seconds) - Total: 0, SQL query: 0, Building
output: 0
1 Row(s) Inserted
Query 21 of 28 elapsed time (seconds) - Total: 0.001, SQL query:
0.001, Building output: 0
1 Row(s) Inserted
Query 22 of 28 elapsed time (seconds) - Total: 0.001, SQL query:
0.001, Building output: 0
1 Row(s) Inserted
Query 23 of 28 elapsed time (seconds) - Total: 0.001, SQL query:
0.001, Building output: 0
1 Row(s) Inserted
Query 24 of 28 elapsed time (seconds) - Total: 0.001, SQL query:
0.001, Building output: 0
1 Row(s) Inserted
Query 25 of 28 elapsed time (seconds) - Total: 0.001, SQL query:
0.001, Building output: 0
1 Row(s) Inserted
Query 26 of 28 elapsed time (seconds) - Total: 0.001, SQL query:
0.001, Building output: 0
1 Row(s) Inserted
Query 27 of 28 elapsed time (seconds) - Total: 0.001, SQL query:
0.001, Building output: 0
Query 28 of 28 elapsed time (seconds) - Total: 0.103, SQL query:
0.002, Building output: 0.101

PKEY         ENTITYCODE  OPERTRID  RECRDSTATUSCODE  RECRDSTATUSDATE
RECRDTYPE  SUBSYSTMNAME  VALADDCODE  VALADDDESCR
                  VALADDKEY                      =20
------------------------------------------------------------------------
------------------------------------------------------------------------
----------------------------------------------
1            PHA         xxxxxx    A
VAR        INV           CAPLMT      9999999
                                                 =20
2            PHA         xxxxxx    A
VAR        INV           COMTYP      ALL
                                                 =20
3            PHA         xxxxxx    A
VAR        INV           DEPT        ALL
                                                 =20
4            PHA         xxxxxx    A
VAR        INV           NSKLMT      9999999
                                                 =20
5            PHA         xxxxxx    A
VAR        INV           PURCH       8681
                                                 =20
6            PHA         xxxxxx    A
VAR        INV           STKLMT      9999999
                                                 =20
7            PHA         xxxxxx    A
VAR        INV           REPORT      ALL
                                                 =20
8            PHP         xxxxxx    A
VAR        INV           ACCT        12500020
                                                 =20
9            PHP         xxxxxx    A
VAR        INV           CAPLMT      9999999
                                                 =20
10           PHP         xxxxxx    A
VAR        INV           COMTYP      ALL
                                                 =20
11           PHP         xxxxxx    A
VAR        INV           DEPT        ALL
                                                 =20
12           PHP         xxxxxx    A
VAR        INV           NSKLMT      9999999
                                                 =20
13           PHP         xxxxxx    A
VAR        INV           PURCH       8681
                                                 =20
14           PHP         xxxxxx    A
VAR        INV           STKLMT      9999999
                                                 =20
15           PHP         xxxxxx    A
VAR        INV           REPORT      ALL
                                                 =20

--
Colin Bell



The information contained in this message and any attachments is intended=
 only for the use of the individual or entity to which it is addressed, a=
nd may contain information that is PRIVILEGED, CONFIDENTIAL, and exempt f=
rom disclosure under applicable law.  If you are not the intended recipie=
nt, you are prohibited from copying, distributing, or using the informati=
on.  Please contact the sender immediately by return e-mail and delete th=
e original message from your system.

Re: [Squirrel-sql-users] MySql

[Colin B. <co...@ba...>]

On Tue, Dec 05, 2006 at 06:52:41AM -0600, Savoy, Melinda wrote:
> Robert,
> 
> Thanks for the response.  I tried what you suggested however, this is
> what is happening.  I have a .sql script whereby I drop tables, create
> tables and then insert data into multiple schemas.
> 
> It would appear that after I run the entire script the DROP tables runs
> successfully but I do not see that any of the tables have been created
> and consequently no data has been inserted.  I have to run the CREATE
> and INSERT separately.

The attached script works for me:

0 Row(s) Updated
Query 1 of 28 elapsed time (seconds) - Total: 0.001, SQL query: 0.001,
Building output: 0
0 Row(s) Updated
Query 2 of 28 elapsed time (seconds) - Total: 0.001, SQL query: 0.001,
Building output: 0
0 Row(s) Updated
Query 3 of 28 elapsed time (seconds) - Total: 0.001, SQL query: 0.001,
Building output: 0
0 Row(s) Updated
Query 4 of 28 elapsed time (seconds) - Total: 0.001, SQL query: 0.001,
Building output: 0
0 Row(s) Updated
Query 5 of 28 elapsed time (seconds) - Total: 0.001, SQL query: 0.001,
Building output: 0
0 Row(s) Updated
Query 6 of 28 elapsed time (seconds) - Total: 0.003, SQL query: 0.003,
Building output: 0
0 Row(s) Updated
Query 7 of 28 elapsed time (seconds) - Total: 0.034, SQL query: 0.034,
Building output: 0
0 Row(s) Updated
Query 8 of 28 elapsed time (seconds) - Total: 0.002, SQL query: 0.002,
Building output: 0
0 Row(s) Updated
Query 9 of 28 elapsed time (seconds) - Total: 0.049, SQL query: 0.049,
Building output: 0
1 Row(s) Updated
Query 10 of 28 elapsed time (seconds) - Total: 0.001, SQL query:
0.001, Building output: 0
1 Row(s) Updated
Query 11 of 28 elapsed time (seconds) - Total: 0.002, SQL query:
0.002, Building output: 0
1 Row(s) Updated
Query 12 of 28 elapsed time (seconds) - Total: 0.001, SQL query:
0.001, Building output: 0
1 Row(s) Updated
Query 13 of 28 elapsed time (seconds) - Total: 0.002, SQL query:
0.002, Building output: 0
1 Row(s) Updated
Query 14 of 28 elapsed time (seconds) - Total: 0.001, SQL query:
0.001, Building output: 0
1 Row(s) Updated
Query 15 of 28 elapsed time (seconds) - Total: 0.001, SQL query:
0.001, Building output: 0
1 Row(s) Updated
Query 16 of 28 elapsed time (seconds) - Total: 0.001, SQL query:
0.001, Building output: 0
1 Row(s) Updated
Query 17 of 28 elapsed time (seconds) - Total: 0, SQL query: 0,
Building output: 0
1 Row(s) Inserted
Query 18 of 28 elapsed time (seconds) - Total: 0.001, SQL query:
0.001, Building output: 0
1 Row(s) Inserted
Query 19 of 28 elapsed time (seconds) - Total: 0.001, SQL query:
0.001, Building output: 0
1 Row(s) Inserted
Query 20 of 28 elapsed time (seconds) - Total: 0, SQL query: 0,
Building output: 0
1 Row(s) Inserted
Query 21 of 28 elapsed time (seconds) - Total: 0.001, SQL query:
0.001, Building output: 0
1 Row(s) Inserted
Query 22 of 28 elapsed time (seconds) - Total: 0.001, SQL query:
0.001, Building output: 0
1 Row(s) Inserted
Query 23 of 28 elapsed time (seconds) - Total: 0.001, SQL query:
0.001, Building output: 0
1 Row(s) Inserted
Query 24 of 28 elapsed time (seconds) - Total: 0.001, SQL query:
0.001, Building output: 0
1 Row(s) Inserted
Query 25 of 28 elapsed time (seconds) - Total: 0.001, SQL query:
0.001, Building output: 0
1 Row(s) Inserted
Query 26 of 28 elapsed time (seconds) - Total: 0.001, SQL query:
0.001, Building output: 0
1 Row(s) Inserted
Query 27 of 28 elapsed time (seconds) - Total: 0.001, SQL query:
0.001, Building output: 0
Query 28 of 28 elapsed time (seconds) - Total: 0.103, SQL query:
0.002, Building output: 0.101

PKEY         ENTITYCODE  OPERTRID  RECRDSTATUSCODE  RECRDSTATUSDATE
RECRDTYPE  SUBSYSTMNAME  VALADDCODE  VALADDDESCR
                  VALADDKEY                       
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1            PHA         xxxxxx    A
VAR        INV           CAPLMT      9999999
                                                  
2            PHA         xxxxxx    A
VAR        INV           COMTYP      ALL
                                                  
3            PHA         xxxxxx    A
VAR        INV           DEPT        ALL
                                                  
4            PHA         xxxxxx    A
VAR        INV           NSKLMT      9999999
                                                  
5            PHA         xxxxxx    A
VAR        INV           PURCH       8681
                                                  
6            PHA         xxxxxx    A
VAR        INV           STKLMT      9999999
                                                  
7            PHA         xxxxxx    A
VAR        INV           REPORT      ALL
                                                  
8            PHP         xxxxxx    A
VAR        INV           ACCT        12500020
                                                  
9            PHP         xxxxxx    A
VAR        INV           CAPLMT      9999999
                                                  
10           PHP         xxxxxx    A
VAR        INV           COMTYP      ALL
                                                  
11           PHP         xxxxxx    A
VAR        INV           DEPT        ALL
                                                  
12           PHP         xxxxxx    A
VAR        INV           NSKLMT      9999999
                                                  
13           PHP         xxxxxx    A
VAR        INV           PURCH       8681
                                                  
14           PHP         xxxxxx    A
VAR        INV           STKLMT      9999999
                                                  
15           PHP         xxxxxx    A
VAR        INV           REPORT      ALL
                                                  

-- 
Colin Bell

Re: [Squirrel-sql-users] 2. Re: Clipboard problem (Colin Bell)

[<dhe...@gr...>]

Thanks, 

I'm using Java 1.4.1.

Others in the office are using same versions of Java and SQuirreL and do 
not have this problem.  I'll try de-installing and reinstalling a later 
version of SQuirreL and see if that helps.

Rgds,
David.




<snip>

On Thu, Nov 30, 2006 at 12:33:22PM +1100, 
dhe...@gr... wrote:

> Everything works ok, except that I cannot paste data from other 
> applications into squirrel (e.g. I have a text file with commonly used 
> sql, but cannot copy and paste it into squirrel).
> If I copy stuff from squirrel then that will past back into squirrel 
(even 
> if I've copied a dozen other things to the Windows clipboard since 
copying 
> it).  It is as though squirrel has it's own clipboard that is totally 
> independent of the windows one.

This works for me. What version of Java are you using?
 
Colin Bell

<snip>

Re: [Squirrel-sql-users] MySql

[Savoy, M. <Mel...@te...>]

Robert,

Thanks for the response.  I tried what you suggested however, this is
what is happening.  I have a .sql script whereby I drop tables, create
tables and then insert data into multiple schemas using the
SCHEMANAME.TABLENAME for qualifying each table.

It would appear that after I submit the entire script the DROP tables
runs successfully but I do not see that any of the tables have been
created and consequently no data has been inserted.  However, I do have
success when I run the CREATE and INSERT statements separately from the
DROP.

Thanks in advance for any additional help or direction that you can give
me.

Regards.



Here is the first part of my script because it is too long I could not
include it all with the insert statements following the create
statements:

DROP TABLE DVCCNTL.DVCCNTL_MSR;
DROP TABLE DVCCNTL.DVCCNTL_SAR;
DROP TABLE DVCCNTL.DVCCNTL_SAR_CODE;
DROP TABLE DVCCNTL.DVCCNTL_VAR;
DROP TABLE INVITEM.INVITEM_ITL;
DROP TABLE INVITVND.INVITVND_VNI;
DROP TABLE INVITVND.INVITVND_VNI_PRICE;
DROP TABLE INVMFR.INVMFR_MFR;
DROP TABLE INVNOTES.INVNOTES;
DROP TABLE INVNOTES.INVNOTES_NOTE;
DROP TABLE INVPICK.INVPICK_TRK;
DROP TABLE INVPO.INVPO_POI_APV;
DROP TABLE INVPO.INVPO_POI;
DROP TABLE INVPO.INVPO_RQI;
DROP TABLE INVPO.INVPO_RQM_APV;
DROP TABLE INVPO.INVPO_RQM;
DROP TABLE INVTBLS.INVTBLS_DEL;
DROP TABLE VENDMSTR.VENDMSTR_VNM;

CREATE TABLE DVCCNTL.DVCCNTL_MSR
(
   PKEY INT PRIMARY KEY not null,
   DEFLTENTITYCODE VARCHAR(3) not null,
   DEPTNAME VARCHAR(40),
   EMAILADDR VARCHAR(40),
   LOCKOUTIND CHAR(1) not null,
   MASTRKEY VARCHAR(12) not null,
   OPERTRID VARCHAR(8) not null,
   RECRDSTATUSCODE CHAR(1) not null,
   RECRDSTATUSDATE VARCHAR(8) not null,
   RECRDTYPE VARCHAR(3) not null,
   USERNAME VARCHAR(40) not null
);

-----Original Message-----
From: Robert Manning [mailto:rob...@gm...]
Sent: Monday, December 04, 2006 4:12 PM
To: Savoy, Melinda
Cc: squ...@li...
Subject: Re: [Squirrel-sql-users] MySql

On 12/4/06, Savoy, Melinda <Mel...@te...> wrote:
>
>
>
> I am using MySql 5.0 and I connected to this database via Squirrel=20
> SQL.  I have multiple schemas/databases under my localhost.  However,=20
> when I try and run a .sql script that drops tables from multiple=20
> schemas & then populates them in the various schemas  I run into an=20
> error saying that it does not recognize the first schema name to drop=20
> the table.  I can run this thru MySQL but not through Squirrel and it
would be great if I could.

As long as in each statement you qualify the table name with the schema
it shouldn't be a problem.  I'm using 5.0.22 and I can create and drop
tables in schemas other than the one I connected to (<dbname> in url
jdbc:mysql://localhost:3306/<dbname>).  Note: there is ongoing
consideration being given to the fact that only one catalog's tables
(catalog is really the term for schema in MySQL) can be accessed in the
object tree based on the catalog selected in the catalog selector at the
top of the session window.

Rob




The information contained in this message and any attachments is intended=
 only for the use of the individual or entity to which it is addressed, a=
nd may contain information that is PRIVILEGED, CONFIDENTIAL, and exempt f=
rom disclosure under applicable law.  If you are not the intended recipie=
nt, you are prohibited from copying, distributing, or using the informati=
on.  Please contact the sender immediately by return e-mail and delete th=
e original message from your system.

Re: [Squirrel-sql-users] MySql

[Savoy, M. <Mel...@te...>]

Robert,

Thanks for the response.  I tried what you suggested however, this is
what is happening.  I have a .sql script whereby I drop tables, create
tables and then insert data into multiple schemas.

It would appear that after I run the entire script the DROP tables runs
successfully but I do not see that any of the tables have been created
and consequently no data has been inserted.  I have to run the CREATE
and INSERT separately.

Thanks in advance for any additional help or direction that you can give
me.

Regards.



Here is the contents of my script:

DROP TABLE DVCCNTL.DVCCNTL_MSR;
DROP TABLE DVCCNTL.DVCCNTL_SAR;
DROP TABLE DVCCNTL.DVCCNTL_SAR_CODE;
DROP TABLE DVCCNTL.DVCCNTL_VAR;
DROP TABLE INVITEM.INVITEM_ITL;
DROP TABLE INVITVND.INVITVND_VNI;
DROP TABLE INVITVND.INVITVND_VNI_PRICE;
DROP TABLE INVMFR.INVMFR_MFR;
DROP TABLE INVNOTES.INVNOTES;
DROP TABLE INVNOTES.INVNOTES_NOTE;
DROP TABLE INVPICK.INVPICK_TRK;
DROP TABLE INVPO.INVPO_POI_APV;
DROP TABLE INVPO.INVPO_POI;
DROP TABLE INVPO.INVPO_RQI;
DROP TABLE INVPO.INVPO_RQM_APV;
DROP TABLE INVPO.INVPO_RQM;
DROP TABLE INVTBLS.INVTBLS_DEL;
DROP TABLE VENDMSTR.VENDMSTR_VNM;

CREATE TABLE DVCCNTL.DVCCNTL_MSR
(
   PKEY INT PRIMARY KEY not null,
   DEFLTENTITYCODE VARCHAR(3) not null,
   DEPTNAME VARCHAR(40),
   EMAILADDR VARCHAR(40),
   LOCKOUTIND CHAR(1) not null,
   MASTRKEY VARCHAR(12) not null,
   OPERTRID VARCHAR(8) not null,
   RECRDSTATUSCODE CHAR(1) not null,
   RECRDSTATUSDATE VARCHAR(8) not null,
   RECRDTYPE VARCHAR(3) not null,
   USERNAME VARCHAR(40) not null
);
CREATE TABLE DVCCNTL.DVCCNTL_SAR
(
   PKEY INT PRIMARY KEY not null,
   ENTITYCODE VARCHAR(3) not null,
   LOCKOUTIND CHAR(1) not null,
   LVLNUM VARCHAR(4) not null,
   OPERTRID VARCHAR(8) not null,
   RECRDSTATUSCODE CHAR(1) not null,
   RECRDSTATUSDATE VARCHAR(8) not null,
   RECRDTYPE VARCHAR(3) not null,
   SUBLVLKEY VARCHAR(25) not null,
   SUBSYSTMNAME VARCHAR(3) not null
);
CREATE TABLE DVCCNTL.DVCCNTL_SAR_CODE
(
   FKEY INT not null,
   AUTHCODE VARCHAR(6) not null
);
CREATE TABLE DVCCNTL.DVCCNTL_VAR
(
   PKEY INT PRIMARY KEY not null,
   ENTITYCODE VARCHAR(3) not null,
   OPERTRID VARCHAR(8) not null,
   RECRDSTATUSCODE CHAR(1) not null,
   RECRDSTATUSDATE VARCHAR(8) not null,
   RECRDTYPE VARCHAR(3) not null,
   SUBSYSTMNAME VARCHAR(3) not null,
   VALADDCODE VARCHAR(6) not null,
   VALADDDESCR VARCHAR(64) not null,
   VALADDKEY VARCHAR(30) not null
);

-- Insert user information for xxxxxx
INSERT INTO DVCCNTL.DVCCNTL_MSR
(PKEY,DEFLTENTITYCODE,MASTRKEY,OPERTRID,LOCKOUTIND,RECRDSTATUSCODE,RECRD
STATUSDATE,RECRDTYPE,USERNAME) VALUES
(1,'PHP','','smithed','N','A','','MSR','xxxxxx');
INSERT INTO DVCCNTL.DVCCNTL_SAR
(PKEY,ENTITYCODE,LVLNUM,RECRDSTATUSCODE,SUBSYSTMNAME,LOCKOUTIND,RECRDTYP
E,OPERTRID,SUBLVLKEY,RECRDSTATUSDATE) VALUES
(1,'PHA','0000','A','INV','N','SAR','xxxxxx','','');
INSERT INTO DVCCNTL.DVCCNTL_SAR
(PKEY,ENTITYCODE,LVLNUM,RECRDSTATUSCODE,SUBSYSTMNAME,LOCKOUTIND,RECRDTYP
E,OPERTRID,SUBLVLKEY,RECRDSTATUSDATE) VALUES
(2,'PHP','9999','A','INV','N','SAR','xxxxxx','','');
INSERT INTO DVCCNTL.DVCCNTL_VAR
(PKEY,VALADDCODE,VALADDDESCR,RECRDSTATUSCODE,SUBSYSTMNAME,RECRDTYPE,ENTI
TYCODE,OPERTRID,VALADDKEY,RECRDSTATUSDATE) VALUES
(1,'CAPLMT','9999999','A','INV','VAR','PHA','xxxxxx','','');
INSERT INTO DVCCNTL.DVCCNTL_VAR
(PKEY,VALADDCODE,VALADDDESCR,RECRDSTATUSCODE,SUBSYSTMNAME,RECRDTYPE,ENTI
TYCODE,OPERTRID,VALADDKEY,RECRDSTATUSDATE) VALUES
(2,'COMTYP','ALL','A','INV','VAR','PHA','xxxxxx','','');
INSERT INTO DVCCNTL.DVCCNTL_VAR
(PKEY,VALADDCODE,VALADDDESCR,RECRDSTATUSCODE,SUBSYSTMNAME,RECRDTYPE,ENTI
TYCODE,OPERTRID,VALADDKEY,RECRDSTATUSDATE) VALUES
(3,'DEPT','ALL','A','INV','VAR','PHA','xxxxxx','','');
INSERT INTO DVCCNTL.DVCCNTL_VAR
(PKEY,VALADDCODE,VALADDDESCR,RECRDSTATUSCODE,SUBSYSTMNAME,RECRDTYPE,ENTI
TYCODE,OPERTRID,VALADDKEY,RECRDSTATUSDATE) VALUES
(4,'NSKLMT','9999999','A','INV','VAR','PHA','xxxxxx','','');
INSERT INTO DVCCNTL.DVCCNTL_VAR
(PKEY,VALADDCODE,VALADDDESCR,RECRDSTATUSCODE,SUBSYSTMNAME,RECRDTYPE,ENTI
TYCODE,OPERTRID,VALADDKEY,RECRDSTATUSDATE) VALUES
(5,'PURCH','8681','A','INV','VAR','PHA','xxxxxx','','');
INSERT INTO DVCCNTL.DVCCNTL_VAR
(PKEY,VALADDCODE,VALADDDESCR,RECRDSTATUSCODE,SUBSYSTMNAME,RECRDTYPE,ENTI
TYCODE,OPERTRID,VALADDKEY,RECRDSTATUSDATE) VALUES
(6,'STKLMT','9999999','A','INV','VAR','PHA','xxxxxx','','');
INSERT INTO DVCCNTL.DVCCNTL_VAR
(PKEY,VALADDCODE,VALADDDESCR,RECRDSTATUSCODE,SUBSYSTMNAME,RECRDTYPE,ENTI
TYCODE,OPERTRID,VALADDKEY,RECRDSTATUSDATE) VALUES
(7,'REPORT','ALL','A','INV','VAR','PHA','xxxxxx','','');
INSERT INTO DVCCNTL.DVCCNTL_VAR
(PKEY,VALADDCODE,VALADDDESCR,RECRDSTATUSCODE,SUBSYSTMNAME,RECRDTYPE,ENTI
TYCODE,OPERTRID,VALADDKEY,RECRDSTATUSDATE) VALUES
(8,'ACCT','12500020','A','INV','VAR','PHP','xxxxxx','','');
INSERT INTO DVCCNTL.DVCCNTL_VAR
(PKEY,VALADDCODE,VALADDDESCR,RECRDSTATUSCODE,SUBSYSTMNAME,RECRDTYPE,ENTI
TYCODE,OPERTRID,VALADDKEY,RECRDSTATUSDATE) VALUES
(9,'CAPLMT','9999999','A','INV','VAR','PHP','xxxxxx','','');
INSERT INTO DVCCNTL.DVCCNTL_VAR
(PKEY,VALADDCODE,VALADDDESCR,RECRDSTATUSCODE,SUBSYSTMNAME,RECRDTYPE,ENTI
TYCODE,OPERTRID,VALADDKEY,RECRDSTATUSDATE) VALUES
(10,'COMTYP','ALL','A','INV','VAR','PHP','xxxxxx','','');
INSERT INTO DVCCNTL.DVCCNTL_VAR
(PKEY,VALADDCODE,VALADDDESCR,RECRDSTATUSCODE,SUBSYSTMNAME,RECRDTYPE,ENTI
TYCODE,OPERTRID,VALADDKEY,RECRDSTATUSDATE) VALUES
(11,'DEPT','ALL','A','INV','VAR','PHP','xxxxxx','','');
INSERT INTO DVCCNTL.DVCCNTL_VAR
(PKEY,VALADDCODE,VALADDDESCR,RECRDSTATUSCODE,SUBSYSTMNAME,RECRDTYPE,ENTI
TYCODE,OPERTRID,VALADDKEY,RECRDSTATUSDATE) VALUES
(12,'NSKLMT','9999999','A','INV','VAR','PHP','xxxxxx','','');
INSERT INTO DVCCNTL.DVCCNTL_VAR
(PKEY,VALADDCODE,VALADDDESCR,RECRDSTATUSCODE,SUBSYSTMNAME,RECRDTYPE,ENTI
TYCODE,OPERTRID,VALADDKEY,RECRDSTATUSDATE) VALUES
(13,'PURCH','8681','A','INV','VAR','PHP','xxxxxx','','');
INSERT INTO DVCCNTL.DVCCNTL_VAR
(PKEY,VALADDCODE,VALADDDESCR,RECRDSTATUSCODE,SUBSYSTMNAME,RECRDTYPE,ENTI
TYCODE,OPERTRID,VALADDKEY,RECRDSTATUSDATE) VALUES
(14,'STKLMT','9999999','A','INV','VAR','PHP','xxxxxx','','');
INSERT INTO DVCCNTL.DVCCNTL_VAR
(PKEY,VALADDCODE,VALADDDESCR,RECRDSTATUSCODE,SUBSYSTMNAME,RECRDTYPE,ENTI
TYCODE,OPERTRID,VALADDKEY,RECRDSTATUSDATE) VALUES
(15,'REPORT','ALL','A','INV','VAR','PHP','xxxxxx','','');
INSERT INTO DVCCNTL.DVCCNTL_SAR_CODE (AUTHCODE,FKEY) VALUES
('51VCON',1);
INSERT INTO DVCCNTL.DVCCNTL_SAR_CODE (AUTHCODE,FKEY) VALUES
('52MCON',1);
INSERT INTO DVCCNTL.DVCCNTL_SAR_CODE (AUTHCODE,FKEY) VALUES
('49CHSP',1);
INSERT INTO DVCCNTL.DVCCNTL_SAR_CODE (AUTHCODE,FKEY) VALUES
('57HNDJ',1);
INSERT INTO DVCCNTL.DVCCNTL_SAR_CODE (AUTHCODE,FKEY) VALUES
('58HNDT',1);
INSERT INTO DVCCNTL.DVCCNTL_SAR_CODE (AUTHCODE,FKEY) VALUES
('61TPRS',1);
INSERT INTO DVCCNTL.DVCCNTL_SAR_CODE (AUTHCODE,FKEY) VALUES
('01VREQ',2);
INSERT INTO DVCCNTL.DVCCNTL_SAR_CODE (AUTHCODE,FKEY) VALUES
('03ASTK',2);
INSERT INTO DVCCNTL.DVCCNTL_SAR_CODE (AUTHCODE,FKEY) VALUES
('04ANSK',2);
INSERT INTO DVCCNTL.DVCCNTL_SAR_CODE (AUTHCODE,FKEY) VALUES
('29VINV',2);
INSERT INTO DVCCNTL.DVCCNTL_SAR_CODE (AUTHCODE,FKEY) VALUES
('40MCOM',2);
INSERT INTO DVCCNTL.DVCCNTL_SAR_CODE (AUTHCODE,FKEY) VALUES
('62HNDP',2);

INSERT INTO INVPO.INVPO_POI (PKEY,
GLACCTNUM,BACKORDRQTY,CAPEXPNSREQSTNUM,CHANGETKTNUM,CHRGTODEPTCODE,COMMN
LIST,CREATEDATE,DELIVRTODEPTCODE,DELIVRTOINDIV,EDIBATCHNUM,EDIDOWNLOADDA
TE,EDIDOWNLOADTIME,EDISTATUS,ENTITYCODE,EOMIND,INVCEFLAGIND,ITEMNUM,LAST
CHGDATE,UNITPRICE,OPERTRID,MFGCATLGNUM,MODELSERIALNUM,NECCODE,NEEDDATE,P
URCHDEPTCODE,ORIGNLVENDORCATNUM,PATIENTENCNTRNUM,PATIENTNAME,PHYSNNAME,P
ONUM,PROMSDDATE,PURUNITOFMEAS,QTYORDRD,QTYRECVD,RECRDSTATUSCODE,RECRDSTA
TUSDATE,RECRDTYPE,REQNDATE,REQNNUM,REQNTOTL,RQILINK,SRCELOCATN,STATIND,R
EQNTYPECODE,VENDORCATLGCHGDATE,VENDORCATLGCHGIND,VENDORNUM,VERIFYDATE,VE
NDORCATLGNUM,POTYPECODE,ITEMDESCR1,ITEMDESCR2,ITEMDESCR3) VALUES
(4,null,null,null,null,'8681',null,'20060510','8681','GENERAL STORES -
BASEMEN',null,null,null,null,'PHA',null,'N',null,'20060510',9.97,'CDPPJR
C',null,null,'1010',null,'8681',null,null,null,null,null,null,'EA00001',
1.0,null,'A','20060510','POI','20060601','10009635',9.97,null,null,'N','
N',null,null,'283',null,'123','REG','JACK TEST',null,null);
INSERT INTO INVPO.INVPO_POI (PKEY,
GLACCTNUM,BACKORDRQTY,CAPEXPNSREQSTNUM,CHANGETKTNUM,CHRGTODEPTCODE,COMMN
LIST,CREATEDATE,DELIVRTODEPTCODE,DELIVRTOINDIV,EDIBATCHNUM,EDIDOWNLOADDA
TE,EDIDOWNLOADTIME,EDISTATUS,ENTITYCODE,EOMIND,INVCEFLAGIND,ITEMNUM,LAST
CHGDATE,UNITPRICE,OPERTRID,MFGCATLGNUM,MODELSERIALNUM,NECCODE,NEEDDATE,P
URCHDEPTCODE,ORIGNLVENDORCATNUM,PATIENTENCNTRNUM,PATIENTNAME,PHYSNNAME,P
ONUM,PROMSDDATE,PURUNITOFMEAS,QTYORDRD,QTYRECVD,RECRDSTATUSCODE,RECRDSTA
TUSDATE,RECRDTYPE,REQNDATE,REQNNUM,REQNTOTL,RQILINK,SRCELOCATN,STATIND,R
EQNTYPECODE,VENDORCATLGCHGDATE,VENDORCATLGCHGIND,VENDORNUM,VERIFYDATE,VE
NDORCATLGNUM,POTYPECODE,ITEMDESCR1,ITEMDESCR2,ITEMDESCR3) VALUES
(6,null,null,null,null,'6000',null,'20060511','8681','GENERAL STORES -
BASEMEN',null,null,null,null,'PHA',null,'N',null,'20060511',0.1,'CDPPJMP
',null,null,'4050',null,'8681',null,null,null,null,null,'20060531','EA00
001',1.0,null,'A','20060511','POI','20060531','10009639',0.1,null,null,'
N','N',null,null,'283',null,'T-1','REG','T-1',null,null);
INSERT INTO INVPO.INVPO_POI (PKEY,
GLACCTNUM,BACKORDRQTY,CAPEXPNSREQSTNUM,CHANGETKTNUM,CHRGTODEPTCODE,COMMN
LIST,CREATEDATE,DELIVRTODEPTCODE,DELIVRTOINDIV,EDIBATCHNUM,EDIDOWNLOADDA
TE,EDIDOWNLOADTIME,EDISTATUS,ENTITYCODE,EOMIND,INVCEFLAGIND,ITEMNUM,LAST
CHGDATE,UNITPRICE,OPERTRID,MFGCATLGNUM,MODELSERIALNUM,NECCODE,NEEDDATE,P
URCHDEPTCODE,ORIGNLVENDORCATNUM,PATIENTENCNTRNUM,PATIENTNAME,PHYSNNAME,P
ONUM,PROMSDDATE,PURUNITOFMEAS,QTYORDRD,QTYRECVD,RECRDSTATUSCODE,RECRDSTA
TUSDATE,RECRDTYPE,REQNDATE,REQNNUM,REQNTOTL,RQILINK,SRCELOCATN,STATIND,R
EQNTYPECODE,VENDORCATLGCHGDATE,VENDORCATLGCHGIND,VENDORNUM,VERIFYDATE,VE
NDORCATLGNUM,POTYPECODE,ITEMDESCR1,ITEMDESCR2,ITEMDESCR3) VALUES
(7,null,null,null,null,'8681',null,'20060524','8681','GENERAL STORES -
BASEMEN',null,null,null,null,'PHA',null,'N',null,'20060524',20.0,'CDPPKR
B',null,null,'4050',null,'8681',null,null,null,null,null,null,'EA00001',
1.0,null,'A','20060524','POI','20060601','10009656',20.0,null,null,'N','
N',null,null,'283',null,'TEST RETUR','REG','TEST RETURN',null,null);
INSERT INTO INVPO.INVPO_POI (PKEY,
GLACCTNUM,BACKORDRQTY,CAPEXPNSREQSTNUM,CHANGETKTNUM,CHRGTODEPTCODE,COMMN
LIST,CREATEDATE,DELIVRTODEPTCODE,DELIVRTOINDIV,EDIBATCHNUM,EDIDOWNLOADDA
TE,EDIDOWNLOADTIME,EDISTATUS,ENTITYCODE,EOMIND,INVCEFLAGIND,ITEMNUM,LAST
CHGDATE,UNITPRICE,OPERTRID,MFGCATLGNUM,MODELSERIALNUM,NECCODE,NEEDDATE,P
URCHDEPTCODE,ORIGNLVENDORCATNUM,PATIENTENCNTRNUM,PATIENTNAME,PHYSNNAME,P
ONUM,PROMSDDATE,PURUNITOFMEAS,QTYORDRD,QTYRECVD,RECRDSTATUSCODE,RECRDSTA
TUSDATE,RECRDTYPE,REQNDATE,REQNNUM,REQNTOTL,RQILINK,SRCELOCATN,STATIND,R
EQNTYPECODE,VENDORCATLGCHGDATE,VENDORCATLGCHGIND,VENDORNUM,VERIFYDATE,VE
NDORCATLGNUM,POTYPECODE,ITEMDESCR1,ITEMDESCR2,ITEMDESCR3) VALUES
(8,null,null,null,null,'8681',null,'20060524','8681','GENERAL STORES -
BASEMEN',null,null,null,null,'PHA',null,'N',null,'20060526',12.0,'CDPPKR
B',null,null,'4050',null,'8681',null,null,null,null,null,null,'EA00001',
1.0,null,'A','20060524','POI','20060601','10009657',12.0,null,null,'N','
N',null,null,'283',null,'TEST DESCR','REG','PUT DESCRIPTION ON LINE
1.',null,null);
INSERT INTO INVPO.INVPO_POI (PKEY,
GLACCTNUM,BACKORDRQTY,CAPEXPNSREQSTNUM,CHANGETKTNUM,CHRGTODEPTCODE,COMMN
LIST,CREATEDATE,DELIVRTODEPTCODE,DELIVRTOINDIV,EDIBATCHNUM,EDIDOWNLOADDA
TE,EDIDOWNLOADTIME,EDISTATUS,ENTITYCODE,EOMIND,INVCEFLAGIND,ITEMNUM,LAST
CHGDATE,UNITPRICE,OPERTRID,MFGCATLGNUM,MODELSERIALNUM,NECCODE,NEEDDATE,P
URCHDEPTCODE,ORIGNLVENDORCATNUM,PATIENTENCNTRNUM,PATIENTNAME,PHYSNNAME,P
ONUM,PROMSDDATE,PURUNITOFMEAS,QTYORDRD,QTYRECVD,RECRDSTATUSCODE,RECRDSTA
TUSDATE,RECRDTYPE,REQNDATE,REQNNUM,REQNTOTL,RQILINK,SRCELOCATN,STATIND,R
EQNTYPECODE,VENDORCATLGCHGDATE,VENDORCATLGCHGIND,VENDORNUM,VERIFYDATE,VE
NDORCATLGNUM,POTYPECODE,ITEMDESCR1,ITEMDESCR2,ITEMDESCR3) VALUES
(9,null,null,null,null,'8681',null,'20060526','8681','GENERAL STORES -
BASEMEN',null,null,null,null,'PHA',null,'N',null,'20060526',25.0,'CDPPKR
B',null,null,'4050',null,'8681',null,null,null,null,null,null,'EA00001',
1.0,null,'A','20060526','POI','20060601','10009658',25.0,null,null,'N','
N',null,null,'283',null,'TEST KRB','REG','TESTING',null,null);
INSERT INTO INVPO.INVPO_POI (PKEY,
GLACCTNUM,BACKORDRQTY,CAPEXPNSREQSTNUM,CHANGETKTNUM,CHRGTODEPTCODE,COMMN
LIST,CREATEDATE,DELIVRTODEPTCODE,DELIVRTOINDIV,EDIBATCHNUM,EDIDOWNLOADDA
TE,EDIDOWNLOADTIME,EDISTATUS,ENTITYCODE,EOMIND,INVCEFLAGIND,ITEMNUM,LAST
CHGDATE,UNITPRICE,OPERTRID,MFGCATLGNUM,MODELSERIALNUM,NECCODE,NEEDDATE,P
URCHDEPTCODE,ORIGNLVENDORCATNUM,PATIENTENCNTRNUM,PATIENTNAME,PHYSNNAME,P
ONUM,PROMSDDATE,PURUNITOFMEAS,QTYORDRD,QTYRECVD,RECRDSTATUSCODE,RECRDSTA
TUSDATE,RECRDTYPE,REQNDATE,REQNNUM,REQNTOTL,RQILINK,SRCELOCATN,STATIND,R
EQNTYPECODE,VENDORCATLGCHGDATE,VENDORCATLGCHGIND,VENDORNUM,VERIFYDATE,VE
NDORCATLGNUM,POTYPECODE,ITEMDESCR1,ITEMDESCR2,ITEMDESCR3) VALUES
(10,null,null,null,null,'6768',null,'20060510','8681','GENERAL STORES -
BASEMEN',null,null,null,null,'PHP',null,'N',null,'20060510',9.97,'CDPPJR
C',null,null,'1010',null,'8681',null,null,null,null,null,null,'EA00001',
1.0,null,'A','20060510','POI','20060601','15687754',9.97,null,null,'N','
N',null,null,'283',null,'123','REG','JACK TEST',null,null);
INSERT INTO INVPO.INVPO_POI (PKEY,
GLACCTNUM,BACKORDRQTY,CAPEXPNSREQSTNUM,CHANGETKTNUM,CHRGTODEPTCODE,COMMN
LIST,CREATEDATE,DELIVRTODEPTCODE,DELIVRTOINDIV,EDIBATCHNUM,EDIDOWNLOADDA
TE,EDIDOWNLOADTIME,EDISTATUS,ENTITYCODE,EOMIND,INVCEFLAGIND,ITEMNUM,LAST
CHGDATE,UNITPRICE,OPERTRID,MFGCATLGNUM,MODELSERIALNUM,NECCODE,NEEDDATE,P
URCHDEPTCODE,ORIGNLVENDORCATNUM,PATIENTENCNTRNUM,PATIENTNAME,PHYSNNAME,P
ONUM,PROMSDDATE,PURUNITOFMEAS,QTYORDRD,QTYRECVD,RECRDSTATUSCODE,RECRDSTA
TUSDATE,RECRDTYPE,REQNDATE,REQNNUM,REQNTOTL,RQILINK,SRCELOCATN,STATIND,R
EQNTYPECODE,VENDORCATLGCHGDATE,VENDORCATLGCHGIND,VENDORNUM,VERIFYDATE,VE
NDORCATLGNUM,POTYPECODE,ITEMDESCR1,ITEMDESCR2,ITEMDESCR3) VALUES
(11,null,null,null,null,'6132',null,'20060511','8681','GENERAL STORES -
BASEMEN',null,null,null,null,'PHP',null,'N',null,'20060511',0.1,'CDPPJMP
',null,null,'4050',null,'8681',null,null,null,null,null,'20060531','EA00
001',1.0,null,'A','20060511','POI','20060531','15687755',0.1,null,null,'
N','N',null,null,'283',null,'T-1','REG','JACK TEST',null,null);
INSERT INTO INVPO.INVPO_POI (PKEY,
GLACCTNUM,BACKORDRQTY,CAPEXPNSREQSTNUM,CHANGETKTNUM,CHRGTODEPTCODE,COMMN
LIST,CREATEDATE,DELIVRTODEPTCODE,DELIVRTOINDIV,EDIBATCHNUM,EDIDOWNLOADDA
TE,EDIDOWNLOADTIME,EDISTATUS,ENTITYCODE,EOMIND,INVCEFLAGIND,ITEMNUM,LAST
CHGDATE,UNITPRICE,OPERTRID,MFGCATLGNUM,MODELSERIALNUM,NECCODE,NEEDDATE,P
URCHDEPTCODE,ORIGNLVENDORCATNUM,PATIENTENCNTRNUM,PATIENTNAME,PHYSNNAME,P
ONUM,PROMSDDATE,PURUNITOFMEAS,QTYORDRD,QTYRECVD,RECRDSTATUSCODE,RECRDSTA
TUSDATE,RECRDTYPE,REQNDATE,REQNNUM,REQNTOTL,RQILINK,SRCELOCATN,STATIND,R
EQNTYPECODE,VENDORCATLGCHGDATE,VENDORCATLGCHGIND,VENDORNUM,VERIFYDATE,VE
NDORCATLGNUM,POTYPECODE,ITEMDESCR1,ITEMDESCR2,ITEMDESCR3) VALUES
(12,null,null,null,null,'8864',null,'20060524','8681','GENERAL STORES -
BASEMEN',null,null,null,null,'PHP',null,'N',null,'20060524',20.0,'CDPPKR
B',null,null,'4050',null,'8681',null,null,null,null,null,null,'EA00001',
1.0,null,'A','20060524','POI','20060601','15687756',20.0,null,null,'N','
N',null,null,'283',null,'TEST RETUR','REG','TEST RETURN',null,null);
INSERT INTO INVPO.INVPO_POI (PKEY,
GLACCTNUM,BACKORDRQTY,CAPEXPNSREQSTNUM,CHANGETKTNUM,CHRGTODEPTCODE,COMMN
LIST,CREATEDATE,DELIVRTODEPTCODE,DELIVRTOINDIV,EDIBATCHNUM,EDIDOWNLOADDA
TE,EDIDOWNLOADTIME,EDISTATUS,ENTITYCODE,EOMIND,INVCEFLAGIND,ITEMNUM,LAST
CHGDATE,UNITPRICE,OPERTRID,MFGCATLGNUM,MODELSERIALNUM,NECCODE,NEEDDATE,P
URCHDEPTCODE,ORIGNLVENDORCATNUM,PATIENTENCNTRNUM,PATIENTNAME,PHYSNNAME,P
ONUM,PROMSDDATE,PURUNITOFMEAS,QTYORDRD,QTYRECVD,RECRDSTATUSCODE,RECRDSTA
TUSDATE,RECRDTYPE,REQNDATE,REQNNUM,REQNTOTL,RQILINK,SRCELOCATN,STATIND,R
EQNTYPECODE,VENDORCATLGCHGDATE,VENDORCATLGCHGIND,VENDORNUM,VERIFYDATE,VE
NDORCATLGNUM,POTYPECODE,ITEMDESCR1,ITEMDESCR2,ITEMDESCR3) VALUES
(13,null,null,null,null,'6398',null,'20060524','8681','GENERAL STORES -
BASEMEN',null,null,null,null,'PHP',null,'N',null,'20060526',12.0,'CDPPKR
B',null,null,'4050',null,'8681',null,null,null,null,null,null,'EA00001',
1.0,null,'A','20060524','POI','20060601','15687757',12.0,null,null,'N','
N',null,null,'283',null,'TEST DESCR','REG','SOME DESCRIPTION
HERE',null,null);
INSERT INTO INVPO.INVPO_POI (PKEY,
GLACCTNUM,BACKORDRQTY,CAPEXPNSREQSTNUM,CHANGETKTNUM,CHRGTODEPTCODE,COMMN
LIST,CREATEDATE,DELIVRTODEPTCODE,DELIVRTOINDIV,EDIBATCHNUM,EDIDOWNLOADDA
TE,EDIDOWNLOADTIME,EDISTATUS,ENTITYCODE,EOMIND,INVCEFLAGIND,ITEMNUM,LAST
CHGDATE,UNITPRICE,OPERTRID,MFGCATLGNUM,MODELSERIALNUM,NECCODE,NEEDDATE,P
URCHDEPTCODE,ORIGNLVENDORCATNUM,PATIENTENCNTRNUM,PATIENTNAME,PHYSNNAME,P
ONUM,PROMSDDATE,PURUNITOFMEAS,QTYORDRD,QTYRECVD,RECRDSTATUSCODE,RECRDSTA
TUSDATE,RECRDTYPE,REQNDATE,REQNNUM,REQNTOTL,RQILINK,SRCELOCATN,STATIND,R
EQNTYPECODE,VENDORCATLGCHGDATE,VENDORCATLGCHGIND,VENDORNUM,VERIFYDATE,VE
NDORCATLGNUM,POTYPECODE,ITEMDESCR1,ITEMDESCR2,ITEMDESCR3) VALUES
(14,null,null,null,null,'7591',null,'20060526','8681','GENERAL STORES -
BASEMEN',null,null,null,null,'PHP',null,'N',null,'20060526',25.0,'CDPPKR
B',null,null,'4050',null,'8681',null,null,null,null,null,null,'EA00001',
1.0,null,'A','20060526','POI','20060601','15687758',25.0,null,null,'N','
N',null,null,'283',null,'TEST KRB','REG','TESTING',null,null);

INSERT INTO INVPO.INVPO_POI_APV (FKEY,NXTACT,APRVDT,APRVTM) VALUES
(4,'xxxxxx','20050908','24:24:24');
INSERT INTO INVPO.INVPO_POI_APV (FKEY,NXTACT,APRVDT,APRVTM) VALUES
(6,'xxxxxx','20060907','02:22:22');
INSERT INTO INVPO.INVPO_POI_APV (FKEY,NXTACT,APRVDT,APRVTM) VALUES
(7,'xxxxxx','20060915','13:30:29');
INSERT INTO INVPO.INVPO_POI_APV (FKEY,NXTACT,APRVDT,APRVTM) VALUES
(8,'xxxxxx','20060916','10:30:18');
INSERT INTO INVPO.INVPO_POI_APV (FKEY,NXTACT,APRVDT,APRVTM) VALUES
(9,'xxxxxx','20060920','07:15:18');
INSERT INTO INVPO.INVPO_POI_APV (FKEY,NXTACT,APRVDT,APRVTM) VALUES
(10,'xxxxxx','20060920','07:15:18');
INSERT INTO INVPO.INVPO_POI_APV (FKEY,NXTACT,APRVDT,APRVTM) VALUES
(11,'xxxxxx','20060920','07:15:18');
INSERT INTO INVPO.INVPO_POI_APV (FKEY,NXTACT,APRVDT,APRVTM) VALUES
(12,'xxxxxx','20060920','07:15:18');
INSERT INTO INVPO.INVPO_POI_APV (FKEY,NXTACT,APRVDT,APRVTM) VALUES
(13,'xxxxxx','20060920','07:15:18');
INSERT INTO INVPO.INVPO_POI_APV (FKEY,NXTACT,APRVDT,APRVTM) VALUES
(14,'xxxxxx','20060920','07:15:18');

INSERT INTO INVPO.INVPO_RQI
(PKEY,GLACCTNUM,BACKORDRQTY,UNITOFMEAS,LOCATNBINCODE,CHRGTODEPTCODE,COMM
NLIST,CREATEDATE,DELIVRTODEPTCODE,FILLDDATE,FILLDQTY,FILLDTIME,ENTITYCOD
E,ITEMNUM,ISSUEIND,LASTCHGDATE,LINEITEMCOUNT,UNITPRICE,OPERTRID,NECCODE,
ORIGQTYORDRD,ORDRDBYDEPTCODE,POILINK,ORDQTY,QTYRECVD,RECRDSTATUSCODE,REC
RDSTATUSDATE,RECRDTYPE,REQNNUM,ISSUEFROMDEPTCODE,TYPESWITCH) VALUES
(28546,null,null,'EA00001',null,'8681',null,'20060509','8681',null,null,
null,'PHA','304510020','I','20060524','1',17.89,'CDPPKRB','4050',null,'8
681',null,2.0,null,'A','20060509','RQI','10009621','8681',null);
INSERT INTO INVPO.INVPO_RQI
(PKEY,GLACCTNUM,BACKORDRQTY,UNITOFMEAS,LOCATNBINCODE,CHRGTODEPTCODE,COMM
NLIST,CREATEDATE,DELIVRTODEPTCODE,FILLDDATE,FILLDQTY,FILLDTIME,ENTITYCOD
E,ITEMNUM,ISSUEIND,LASTCHGDATE,LINEITEMCOUNT,UNITPRICE,OPERTRID,NECCODE,
ORIGQTYORDRD,ORDRDBYDEPTCODE,POILINK,ORDQTY,QTYRECVD,RECRDSTATUSCODE,REC
RDSTATUSDATE,RECRDTYPE,REQNNUM,ISSUEFROMDEPTCODE,TYPESWITCH) VALUES
(28554,null,null,'EA00001',null,'8681','CART6000','20060509','8681',null
,null,null,'PHA','304510075','I','20060509','1',0.45,'UNGTH','0510',null
,'8681',null,1.0,null,'A','20060509','RQI','387','8681',null);
INSERT INTO INVPO.INVPO_RQI
(PKEY,GLACCTNUM,BACKORDRQTY,UNITOFMEAS,LOCATNBINCODE,CHRGTODEPTCODE,COMM
NLIST,CREATEDATE,DELIVRTODEPTCODE,FILLDDATE,FILLDQTY,FILLDTIME,ENTITYCOD
E,ITEMNUM,ISSUEIND,LASTCHGDATE,LINEITEMCOUNT,UNITPRICE,OPERTRID,NECCODE,
ORIGQTYORDRD,ORDRDBYDEPTCODE,POILINK,ORDQTY,QTYRECVD,RECRDSTATUSCODE,REC
RDSTATUSDATE,RECRDTYPE,REQNNUM,ISSUEFROMDEPTCODE,TYPESWITCH) VALUES
(28569,null,null,'EA00001',null,'6000','JMP','20060511','8681',null,null
,null,'PHA','304510183','B','20060511','1',0.05,'CDPPJMP','4057',null,'8
681',null,1.0,null,'A','20060511','RQI','10009637','6000',null);
INSERT INTO INVPO.INVPO_RQI
(PKEY,GLACCTNUM,BACKORDRQTY,UNITOFMEAS,LOCATNBINCODE,CHRGTODEPTCODE,COMM
NLIST,CREATEDATE,DELIVRTODEPTCODE,FILLDDATE,FILLDQTY,FILLDTIME,ENTITYCOD
E,ITEMNUM,ISSUEIND,LASTCHGDATE,LINEITEMCOUNT,UNITPRICE,OPERTRID,NECCODE,
ORIGQTYORDRD,ORDRDBYDEPTCODE,POILINK,ORDQTY,QTYRECVD,RECRDSTATUSCODE,REC
RDSTATUSDATE,RECRDTYPE,REQNNUM,ISSUEFROMDEPTCODE,TYPESWITCH) VALUES
(28571,null,null,'EA00001',null,'8681','JMP','20060511','8681',null,null
,null,'PHP','304588970','B',null,'1',5.2,'CDPPJMP','4080',null,'8681',nu
ll,1.0,null,'A','20060511','RQI','10009638','6000',null);
INSERT INTO INVPO.INVPO_RQI
(PKEY,GLACCTNUM,BACKORDRQTY,UNITOFMEAS,LOCATNBINCODE,CHRGTODEPTCODE,COMM
NLIST,CREATEDATE,DELIVRTODEPTCODE,FILLDDATE,FILLDQTY,FILLDTIME,ENTITYCOD
E,ITEMNUM,ISSUEIND,LASTCHGDATE,LINEITEMCOUNT,UNITPRICE,OPERTRID,NECCODE,
ORIGQTYORDRD,ORDRDBYDEPTCODE,POILINK,ORDQTY,QTYRECVD,RECRDSTATUSCODE,REC
RDSTATUSDATE,RECRDTYPE,REQNNUM,ISSUEFROMDEPTCODE,TYPESWITCH) VALUES
(28593,null,null,'EA00001',null,'8681','JMP','20060517','8681',null,null
,null,'PHP','304588972','B','20060517','1',1.02,'CDPPJRC','0510',null,'8
681',null,1.0,null,'A','20060517','RQI','10009653','7000',null);

INSERT INTO INVPO.INVPO_RQM
(PKEY,GLACCTNUM,CAPEXPNSREQST,CHANGETKTNUM,CHRGTODEPTCODE,CHGDELIVRYIND,
COMMNLIST,CREATEDATE,DELIVRTODEPTCODE,DELIVRTODEPTLOC,ENTITYCODE,INVCEFL
AGIND,ISSUEIND,OPERTRID,MODELSERIALNUM,ORDRDBYDEPTCODE,PATIENTENCNTRNUM,
PATIENTNAME,PHYSNNAME,RECRDSTATUSCODE,RECRDSTATUSDATE,RECRDTYPE,REQNDATE
,REQNNUM,REQNTOTLAMT,REQSTDDELIVRYDATE,REVSDDELIVRYDATE,ISSUEFROMDEPTCOD
E,SCHEDDELIVRYDATE,TYPESWITCH) VALUES
(499,null,null,null,'6000',null,null,'19940118','6000','PACU LEVEL 2
TOWER','PHA',null,'I','CDPPJJS',null,'6000',null,null,null,'A','20051003
','RQM','19940118','10009621',null,null,null,'8681','19940119','I');
INSERT INTO INVPO.INVPO_RQM
(PKEY,GLACCTNUM,CAPEXPNSREQST,CHANGETKTNUM,CHRGTODEPTCODE,CHGDELIVRYIND,
COMMNLIST,CREATEDATE,DELIVRTODEPTCODE,DELIVRTODEPTLOC,ENTITYCODE,INVCEFL
AGIND,ISSUEIND,OPERTRID,MODELSERIALNUM,ORDRDBYDEPTCODE,PATIENTENCNTRNUM,
PATIENTNAME,PHYSNNAME,RECRDSTATUSCODE,RECRDSTATUSDATE,RECRDTYPE,REQNDATE
,REQNNUM,REQNTOTLAMT,REQSTDDELIVRYDATE,REVSDDELIVRYDATE,ISSUEFROMDEPTCOD
E,SCHEDDELIVRYDATE,TYPESWITCH) VALUES
(849,null,null,null,'SPLT',null,null,'19940121','SPLT','RAD LEVEL
3','PHA',null,'I','CDPPRWP',null,'6000',null,null,null,'A','20051003','R
QM','19940121','387',null,null,null,'8681','19940124','I');
INSERT INTO INVPO.INVPO_RQM
(PKEY,GLACCTNUM,CAPEXPNSREQST,CHANGETKTNUM,CHRGTODEPTCODE,CHGDELIVRYIND,
COMMNLIST,CREATEDATE,DELIVRTODEPTCODE,DELIVRTODEPTLOC,ENTITYCODE,INVCEFL
AGIND,ISSUEIND,OPERTRID,MODELSERIALNUM,ORDRDBYDEPTCODE,PATIENTENCNTRNUM,
PATIENTNAME,PHYSNNAME,RECRDSTATUSCODE,RECRDSTATUSDATE,RECRDTYPE,REQNDATE
,REQNNUM,REQNTOTLAMT,REQSTDDELIVRYDATE,REVSDDELIVRYDATE,ISSUEFROMDEPTCOD
E,SCHEDDELIVRYDATE,TYPESWITCH) VALUES
(7056,null,null,null,'7002',null,'PACU','20051114','7002','PACU LEVEL 2
TOWER
B','PHA',null,'I','UNGTH',null,'7002',null,null,null,'A','20051114','RQM
','20051114','10009637',97.24,null,null,'6000','20051114','I');
INSERT INTO INVPO.INVPO_RQM
(PKEY,GLACCTNUM,CAPEXPNSREQST,CHANGETKTNUM,CHRGTODEPTCODE,CHGDELIVRYIND,
COMMNLIST,CREATEDATE,DELIVRTODEPTCODE,DELIVRTODEPTLOC,ENTITYCODE,INVCEFL
AGIND,ISSUEIND,OPERTRID,MODELSERIALNUM,ORDRDBYDEPTCODE,PATIENTENCNTRNUM,
PATIENTNAME,PHYSNNAME,RECRDSTATUSCODE,RECRDSTATUSDATE,RECRDTYPE,REQNDATE
,REQNNUM,REQNTOTLAMT,REQSTDDELIVRYDATE,REVSDDELIVRYDATE,ISSUEFROMDEPTCOD
E,SCHEDDELIVRYDATE,TYPESWITCH) VALUES
(17940,null,null,null,'7006',null,null,'20051114','7006','SURGERY LEVEL
2 TOWER
A','PHP','Y','I','WEB.APPR',null,'7006','90548547491559','S135','Y52','A
','20051114','RQM','20051114','10009638',600.0,null,null,'6000','2005111
5','I');
INSERT INTO INVPO.INVPO_RQM
(PKEY,GLACCTNUM,CAPEXPNSREQST,CHANGETKTNUM,CHRGTODEPTCODE,CHGDELIVRYIND,
COMMNLIST,CREATEDATE,DELIVRTODEPTCODE,DELIVRTODEPTLOC,ENTITYCODE,INVCEFL
AGIND,ISSUEIND,OPERTRID,MODELSERIALNUM,ORDRDBYDEPTCODE,PATIENTENCNTRNUM,
PATIENTNAME,PHYSNNAME,RECRDSTATUSCODE,RECRDSTATUSDATE,RECRDTYPE,REQNDATE
,REQNNUM,REQNTOTLAMT,REQSTDDELIVRYDATE,REVSDDELIVRYDATE,ISSUEFROMDEPTCOD
E,SCHEDDELIVRYDATE,TYPESWITCH) VALUES
(17953,null,null,null,'6620',null,'ZPSCU','20051110','6620','LEVEL 2
LINK BEHIND
DSCU','PHP',null,'I','CDPPKRB',null,'6620',null,null,null,'A','20051110'
,'RQM','20051110','10009653',null,null,null,'7000','20051111','I');

INSERT INTO INVPO.INVPO_RQM_APV (FKEY,NXTACT,APRVDT,APRVTM) VALUES
(499,'savoym','20050905','01:01:01');
INSERT INTO INVPO.INVPO_RQM_APV (FKEY,NXTACT,APRVDT,APRVTM) VALUES
(849,'savoym','20060906','01:11:11');
INSERT INTO INVPO.INVPO_RQM_APV (FKEY,NXTACT,APRVDT,APRVTM) VALUES
(7056, 'savoym','20060915','13:30:29');
INSERT INTO INVPO.INVPO_RQM_APV (FKEY,NXTACT,APRVDT,APRVTM) VALUES
(17940, 'savoym','20060916','10:30:18');
INSERT INTO INVPO.INVPO_RQM_APV (FKEY,NXTACT,APRVDT,APRVTM) VALUES
(17953, 'savoym','20060920','07:15:18');

INSERT INTO INVITEM.INVITEM_ITL
(PKEY,ACTUALUSAGE,AUTOREPLNSHIND,CALCDOQIND,CRITICALITEMIND,CRITICALQTY,
CREATEDATE,AVGUSECALCDATE,LASTUSAGEDATE,PURCHSNGDEPTCODE,DESIRDINVDAYS,D
YNAMCORDRQTY,ENTITYCODE,ISSUEIND,LOCATNBINCODE,LOCATNDEPTCODE,ITEMNUM,LA
STCHGDATE,NECCODE,PARLEVEL,PATIENTCHGIND,PROBLMIND,OWEDQTY,ONHANDQTY,ONO
RDRQTY,RECRDSTATUSCODE,RECRDSTATUSDATE,RECRDTYPE,REORDRPTVOLUME,REPLNSHF
ROMDEPT,SAFETYSTKDAYS,STKIND,STKLVL) VALUES
(3454,78.7,'Y','N','N',0.0,'20000828','20060125','20060125','8681',14.0,
500.0,'PHA',null,'RECV10','8681','304510020','20030828','4545',null,'N',
null,0.0,541.0,null,'A','20000828','ITL',260.0,'VNDR',7.0,'Y',1.0);
INSERT INTO INVITEM.INVITEM_ITL
(PKEY,ACTUALUSAGE,AUTOREPLNSHIND,CALCDOQIND,CRITICALITEMIND,CRITICALQTY,
CREATEDATE,AVGUSECALCDATE,LASTUSAGEDATE,PURCHSNGDEPTCODE,DESIRDINVDAYS,D
YNAMCORDRQTY,ENTITYCODE,ISSUEIND,LOCATNBINCODE,LOCATNDEPTCODE,ITEMNUM,LA
STCHGDATE,NECCODE,PARLEVEL,PATIENTCHGIND,PROBLMIND,OWEDQTY,ONHANDQTY,ONO
RDRQTY,RECRDSTATUSCODE,RECRDSTATUSDATE,RECRDTYPE,REORDRPTVOLUME,REPLNSHF
ROMDEPT,SAFETYSTKDAYS,STKIND,STKLVL) VALUES
(3455,0.24,'N','N','N',0.0,'20020812','20060124',null,'8681',0.0,0.0,'PH
A',null,null,'8681','304510075',null,'4050',null,'Y',null,null,null,null
,'A','20020812','ITL',0.0,'VNDR',0.0,'N',1.0);
INSERT INTO INVITEM.INVITEM_ITL
(PKEY,ACTUALUSAGE,AUTOREPLNSHIND,CALCDOQIND,CRITICALITEMIND,CRITICALQTY,
CREATEDATE,AVGUSECALCDATE,LASTUSAGEDATE,PURCHSNGDEPTCODE,DESIRDINVDAYS,D
YNAMCORDRQTY,ENTITYCODE,ISSUEIND,LOCATNBINCODE,LOCATNDEPTCODE,ITEMNUM,LA
STCHGDATE,NECCODE,PARLEVEL,PATIENTCHGIND,PROBLMIND,OWEDQTY,ONHANDQTY,ONO
RDRQTY,RECRDSTATUSCODE,RECRDSTATUSDATE,RECRDTYPE,REORDRPTVOLUME,REPLNSHF
ROMDEPT,SAFETYSTKDAYS,STKIND,STKLVL) VALUES
(3456,-0.28,'Y','N','N',0.0,'20060310','20060603','20060310','8681',2.0,
0.0,'PHA',null,null,'6000','304510183',null,'4050',null,null,null,null,2
4.0,null,'A','20060310','ITL',0.0,'VNDR',1.0,'Y',1.0);
INSERT INTO INVITEM.INVITEM_ITL
(PKEY,ACTUALUSAGE,AUTOREPLNSHIND,CALCDOQIND,CRITICALITEMIND,CRITICALQTY,
CREATEDATE,AVGUSECALCDATE,LASTUSAGEDATE,PURCHSNGDEPTCODE,DESIRDINVDAYS,D
YNAMCORDRQTY,ENTITYCODE,ISSUEIND,LOCATNBINCODE,LOCATNDEPTCODE,ITEMNUM,LA
STCHGDATE,NECCODE,PARLEVEL,PATIENTCHGIND,PROBLMIND,OWEDQTY,ONHANDQTY,ONO
RDRQTY,RECRDSTATUSCODE,RECRDSTATUSDATE,RECRDTYPE,REORDRPTVOLUME,REPLNSHF
ROMDEPT,SAFETYSTKDAYS,STKIND,STKLVL) VALUES
(3457,-0.16,'Y','N','N',0.0,'20060404','20060604','20060404','8681',2.0,
0.0,'PHP',null,null,'6000','304588970',null,'4050',null,null,null,null,1
0.0,null,'A','20060404','ITL',0.0,'VNDR',1.0,'Y',1.0);
INSERT INTO INVITEM.INVITEM_ITL
(PKEY,ACTUALUSAGE,AUTOREPLNSHIND,CALCDOQIND,CRITICALITEMIND,CRITICALQTY,
CREATEDATE,AVGUSECALCDATE,LASTUSAGEDATE,PURCHSNGDEPTCODE,DESIRDINVDAYS,D
YNAMCORDRQTY,ENTITYCODE,ISSUEIND,LOCATNBINCODE,LOCATNDEPTCODE,ITEMNUM,LA
STCHGDATE,NECCODE,PARLEVEL,PATIENTCHGIND,PROBLMIND,OWEDQTY,ONHANDQTY,ONO
RDRQTY,RECRDSTATUSCODE,RECRDSTATUSDATE,RECRDTYPE,REORDRPTVOLUME,REPLNSHF
ROMDEPT,SAFETYSTKDAYS,STKIND,STKLVL) VALUES
(3458,null,'N','N','N',0.0,'20060509',null,null,'8681',0.0,0.0,'PHP',nul
l,null,'7000','304588972',null,'4050',null,null,null,null,null,null,'A',
'20060509','ITL',0.0,'VNDR',0.0,'N',1.0);

INSERT INTO INVITVND.INVITVND_VNI
(PKEY,AUTOSUBIND,VENDORCONTRCTNUM,CREATEDATE,ENTITYCODE,ITEMNUM,LASTCHGD
ATE,LEADTIME,MFRCATLGNUM,MFRNUM,ORDRMULTINUM,PREFRNCECODE,PRIMARYKEY,VEN
DORRANKING,PURUNITOFMEAS,RECRDSTATUSCODE,RECRDSTATUSDATE,RECRDTYPE,SEQNU
M,VENDORCATLGNUM,VENDORDESCR,VENDORNUM,MFRCONTRCTNUM) VALUES
(125,'Y',null,'20060601','PHA','304510020',null,3.0,'HSC987654','3050',5
=2E0,'01','AVNIHAR3045050020102','01','EA00001','A','19891218','VNI','2',=
'
NONE','DRIP PAN - SEMI-STERILE','1480',null);
INSERT INTO INVITVND.INVITVND_VNI
(PKEY,AUTOSUBIND,VENDORCONTRCTNUM,CREATEDATE,ENTITYCODE,ITEMNUM,LASTCHGD
ATE,LEADTIME,MFRCATLGNUM,MFRNUM,ORDRMULTINUM,PREFRNCECODE,PRIMARYKEY,VEN
DORRANKING,PURUNITOFMEAS,RECRDSTATUSCODE,RECRDSTATUSDATE,RECRDTYPE,SEQNU
M,VENDORCATLGNUM,VENDORDESCR,VENDORNUM,MFRCONTRCTNUM) VALUES
(126,'N',null,'20060101','PHA','304510075',null,5.0,'998776655','7840',2
=2E0,'01','AVNIHAR3045050020103','01','EA00001','A','19891218','VNI','3',=
'
IBM-1212','STERILE PROCEDURE BASIN','1480',null);
INSERT INTO INVITVND.INVITVND_VNI
(PKEY,AUTOSUBIND,VENDORCONTRCTNUM,CREATEDATE,ENTITYCODE,ITEMNUM,LASTCHGD
ATE,LEADTIME,MFRCATLGNUM,MFRNUM,ORDRMULTINUM,PREFRNCECODE,PRIMARYKEY,VEN
DORRANKING,PURUNITOFMEAS,RECRDSTATUSCODE,RECRDSTATUSDATE,RECRDTYPE,SEQNU
M,VENDORCATLGNUM,VENDORDESCR,VENDORNUM,MFRCONTRCTNUM) VALUES
(127,'N',null,'20061201','PHA','304510183',null,1.0,'J&J111222','8441',3
=2E0,'01','AVNIHAR3045050020104','01','EA00001','A','19891218','VNI','4',=
'
IBM-1213','BASIN, PROCEDURE, STERILE','1480',null);
INSERT INTO INVITVND.INVITVND_VNI
(PKEY,AUTOSUBIND,VENDORCONTRCTNUM,CREATEDATE,ENTITYCODE,ITEMNUM,LASTCHGD
ATE,LEADTIME,MFRCATLGNUM,MFRNUM,ORDRMULTINUM,PREFRNCECODE,PRIMARYKEY,VEN
DORRANKING,PURUNITOFMEAS,RECRDSTATUSCODE,RECRDSTATUSDATE,RECRDTYPE,SEQNU
M,VENDORCATLGNUM,VENDORDESCR,VENDORNUM,MFRCONTRCTNUM) VALUES
(128,'N',null,'20040115','PHP','304588970','20040317',3.0,'HSC987654','2
069',1.0,'01','AVNIHSW3045050029902','01','EA00001','A','20040317','VNI'
,'2','NONE','DRIP PAN - SEMI-STERILE','1480',null);
INSERT INTO INVITVND.INVITVND_VNI
(PKEY,AUTOSUBIND,VENDORCONTRCTNUM,CREATEDATE,ENTITYCODE,ITEMNUM,LASTCHGD
ATE,LEADTIME,MFRCATLGNUM,MFRNUM,ORDRMULTINUM,PREFRNCECODE,PRIMARYKEY,VEN
DORRANKING,PURUNITOFMEAS,RECRDSTATUSCODE,RECRDSTATUSDATE,RECRDTYPE,SEQNU
M,VENDORCATLGNUM,VENDORDESCR,VENDORNUM,MFRCONTRCTNUM) VALUES
(129,'Y',null,'20060504','PHP','304588972',null,3.0,'XXX666','7840',1.0,
'01','AVNIHAR3050001280801','01','CS00100','A','19900119','VNI','1','121
212126666666','24D TRIEX TABS 2773222 HYDROPHOBIC','39',null);

INSERT INTO INVITVND.INVITVND_VNI_PRICE (PURPRICE,PURPRICEDATE,FKEY)
VALUES (15.0,'20040219',125);
INSERT INTO INVITVND.INVITVND_VNI_PRICE (PURPRICE,PURPRICEDATE,FKEY)
VALUES (47.5,'19901013',126);
INSERT INTO INVITVND.INVITVND_VNI_PRICE (PURPRICE,PURPRICEDATE,FKEY)
VALUES (0.0,'19881001',127);
INSERT INTO INVITVND.INVITVND_VNI_PRICE (PURPRICE,PURPRICEDATE,FKEY)
VALUES (100.0,'19881001',128);
INSERT INTO INVITVND.INVITVND_VNI_PRICE (PURPRICE,PURPRICEDATE,FKEY)
VALUES (135.0,'19970904',129);

INSERT INTO INVMFR.INVMFR_MFR
(PKEY,EXTRNLMFRNUM,LASTCHGDATE,MFRNAME,MFRNUM,MFRTYPECODE,PARENTEXTRNLNU
M,PARENTNAME,PARENTNUM,RECRDSTATUSCODE,RECRDSTATUSDATE,RECRDTYPE,OPERTRI
D) VALUES (0,'1234567890123','20060601','JOHNSON & JOHNSON
INC.','3050','HIN',null,null,null,'A','20020705','MFR','CDPPKRB');
INSERT INTO INVMFR.INVMFR_MFR
(PKEY,EXTRNLMFRNUM,LASTCHGDATE,MFRNAME,MFRNUM,MFRTYPECODE,PARENTEXTRNLNU
M,PARENTNAME,PARENTNUM,RECRDSTATUSCODE,RECRDSTATUSDATE,RECRDTYPE,OPERTRI
D) VALUES (1,'1234567890XXX',null,'J &
J','7840','DUN','1234567890123','JOHNSON &
JOHNSON','1','A','20020705','MFR',null);
INSERT INTO INVMFR.INVMFR_MFR
(PKEY,EXTRNLMFRNUM,LASTCHGDATE,MFRNAME,MFRNUM,MFRTYPECODE,PARENTEXTRNLNU
M,PARENTNAME,PARENTNUM,RECRDSTATUSCODE,RECRDSTATUSDATE,RECRDTYPE,OPERTRI
D) VALUES
(2,'1234567890','20030107','JOHNSON','8441','DUN','1234567890123','JOHNS
ON & JOHNSON','1','A','20040704','MFR','CDPPJRC');
INSERT INTO INVMFR.INVMFR_MFR
(PKEY,EXTRNLMFRNUM,LASTCHGDATE,MFRNAME,MFRNUM,MFRTYPECODE,PARENTEXTRNLNU
M,PARENTNAME,PARENTNUM,RECRDSTATUSCODE,RECRDSTATUSDATE,RECRDTYPE,OPERTRI
D) VALUES
(3,'ABCDEFGHIJKLM','20030203','SURGIKOS','2069','GLN',null,null,null,'A'
,'20060501','MFR','CDPPJMP');
INSERT INTO INVMFR.INVMFR_MFR
(PKEY,EXTRNLMFRNUM,LASTCHGDATE,MFRNAME,MFRNUM,MFRTYPECODE,PARENTEXTRNLNU
M,PARENTNAME,PARENTNUM,RECRDSTATUSCODE,RECRDSTATUSDATE,RECRDTYPE,OPERTRI
D) VALUES (4,'1876512340000',null,'SURGICAL SUPPLY
COMPANY','2840','GLN',null,null,'4','A','20060205','MFR',null);

INSERT INTO INVNOTES.INVNOTES
(PKEY,ENTITYCODE,ENTRYDATE,ENTRYTIME,ITEMNUM,OPERTRID,RECRDSTATUSCODE,RE
CRDSTATUSDATE,RECRDTYPE) VALUES (1,'PHA','20060705','123450','12345678
','CDPPKWM ','A','20050908','REQ');
INSERT INTO INVNOTES.INVNOTES
(PKEY,ENTITYCODE,ENTRYDATE,ENTRYTIME,ITEMNUM,OPERTRID,RECRDSTATUSCODE,RE
CRDSTATUSDATE,RECRDTYPE) VALUES (2,'PHA','20060706','143451','12345678
','CDPPKWR ','A','20050912','REQ');
INSERT INTO INVNOTES.INVNOTES
(PKEY,ENTITYCODE,ENTRYDATE,ENTRYTIME,ITEMNUM,OPERTRID,RECRDSTATUSCODE,RE
CRDSTATUSDATE,RECRDTYPE) VALUES (3,'PHA','20060707','143452','12345678
','CDPPKWS ','A','20050913','REQ');
INSERT INTO INVNOTES.INVNOTES
(PKEY,ENTITYCODE,ENTRYDATE,ENTRYTIME,ITEMNUM,OPERTRID,RECRDSTATUSCODE,RE
CRDSTATUSDATE,RECRDTYPE) VALUES (4,'PHA','20060707','143452','09458641
','CDPPKWM ','A','20050907','REQ');
INSERT INTO INVNOTES.INVNOTES
(PKEY,ENTITYCODE,ENTRYDATE,ENTRYTIME,ITEMNUM,OPERTRID,RECRDSTATUSCODE,RE
CRDSTATUSDATE,RECRDTYPE) VALUES (5,'PHP','20060601','084648','12345678
','CDPPKWM ','A','20060601','POI');
INSERT INTO INVNOTES.INVNOTES
(PKEY,ENTITYCODE,ENTRYDATE,ENTRYTIME,ITEMNUM,OPERTRID,RECRDSTATUSCODE,RE
CRDSTATUSDATE,RECRDTYPE) VALUES (6,'PHP','20060601','084648','12345678
','CDPPKWR ','A','20060601','POI');
INSERT INTO INVNOTES.INVNOTES
(PKEY,ENTITYCODE,ENTRYDATE,ENTRYTIME,ITEMNUM,OPERTRID,RECRDSTATUSCODE,RE
CRDSTATUSDATE,RECRDTYPE) VALUES (7,'PHP','20060601','084648','12345678
','CDPPKWS ','A','20060601','POI');

INSERT INTO INVNOTES.INVNOTES_NOTE (FKEY,NOTE) VALUES (1,'This is note
#1-1.');
INSERT INTO INVNOTES.INVNOTES_NOTE (FKEY,NOTE) VALUES (1,'This is note
#1-2.');
INSERT INTO INVNOTES.INVNOTES_NOTE (FKEY,NOTE) VALUES (1,'This is note
#1-3.');
INSERT INTO INVNOTES.INVNOTES_NOTE (FKEY,NOTE) VALUES (1,'This is note
#1-4.');
INSERT INTO INVNOTES.INVNOTES_NOTE (FKEY,NOTE) VALUES (1,'This is note
#1-5.');
INSERT INTO INVNOTES.INVNOTES_NOTE (FKEY,NOTE) VALUES (1,'This is note
#1-6.');
INSERT INTO INVNOTES.INVNOTES_NOTE (FKEY,NOTE) VALUES (1,'This is note
#1-7.');
INSERT INTO INVNOTES.INVNOTES_NOTE (FKEY,NOTE) VALUES (1,'This is note
#1-8.');
INSERT INTO INVNOTES.INVNOTES_NOTE (FKEY,NOTE) VALUES (2,'This is note
#2-1.');
INSERT INTO INVNOTES.INVNOTES_NOTE (FKEY,NOTE) VALUES (3,'This is note
#3-1.');
INSERT INTO INVNOTES.INVNOTES_NOTE (FKEY,NOTE) VALUES (3,'This is note
#3-2.');
INSERT INTO INVNOTES.INVNOTES_NOTE (FKEY,NOTE) VALUES (4,'This is note
#4-1.');
INSERT INTO INVNOTES.INVNOTES_NOTE (FKEY,NOTE) VALUES (5,'This is note
#1-1.');
INSERT INTO INVNOTES.INVNOTES_NOTE (FKEY,NOTE) VALUES (5,'This is note
#1-2.');
INSERT INTO INVNOTES.INVNOTES_NOTE (FKEY,NOTE) VALUES (5,'This is note
#1-3.');
INSERT INTO INVNOTES.INVNOTES_NOTE (FKEY,NOTE) VALUES (5,'This is note
#1-4.');
INSERT INTO INVNOTES.INVNOTES_NOTE (FKEY,NOTE) VALUES (5,'This is note
#1-5.');
INSERT INTO INVNOTES.INVNOTES_NOTE (FKEY,NOTE) VALUES (5,'This is note
#1-6.');
INSERT INTO INVNOTES.INVNOTES_NOTE (FKEY,NOTE) VALUES (6,'This is note
#2-1.');
INSERT INTO INVNOTES.INVNOTES_NOTE (FKEY,NOTE) VALUES (7,'This is note
#3-1.');
INSERT INTO INVNOTES.INVNOTES_NOTE (FKEY,NOTE) VALUES (7,'This is note
#3-2.');

INSERT INTO INVTBLS.INVTBLS_DEL
(PKEY,ENTITYCODE,DEPTNUM,LASTCHGDATE,LOCATNDESCR,LOCATNNAME,OPERTRID,REC
RDSTATUSCODE,RECRDSTATUSDATE,RECRDTYPE) VALUES
(45,'PHA','4050','20040101','PHA','BAXTER HOSPITAL
SUPPLY','MARTINK','A','19950717','TPR');
INSERT INTO INVTBLS.INVTBLS_DEL
(PKEY,ENTITYCODE,DEPTNUM,LASTCHGDATE,LOCATNDESCR,LOCATNNAME,OPERTRID,REC
RDSTATUSCODE,RECRDSTATUSDATE,RECRDTYPE) VALUES
(46,'PHA','5151','20040101','PHA','BAXTER
SCIENTIFIC','SMITHED','A','19950717','TPR');
INSERT INTO INVTBLS.INVTBLS_DEL
(PKEY,ENTITYCODE,DEPTNUM,LASTCHGDATE,LOCATNDESCR,LOCATNNAME,OPERTRID,REC
RDSTATUSCODE,RECRDSTATUSDATE,RECRDTYPE) VALUES
(47,'PHA','7845','20040101','PHA','BAXTER HOSPITAL
(EDS)','SAVOYM','D','19980217','TPR');
INSERT INTO INVTBLS.INVTBLS_DEL
(PKEY,ENTITYCODE,DEPTNUM,LASTCHGDATE,LOCATNDESCR,LOCATNNAME,OPERTRID,REC
RDSTATUSCODE,RECRDSTATUSDATE,RECRDTYPE) VALUES
(48,'PHP','7815','20040101','PHP','BAXTER HOSPITAL
(VMUELLER)','SAVOYM','A','19950706','TPR');
INSERT INTO INVTBLS.INVTBLS_DEL
(PKEY,ENTITYCODE,DEPTNUM,LASTCHGDATE,LOCATNDESCR,LOCATNNAME,OPERTRID,REC
RDSTATUSCODE,RECRDSTATUSDATE,RECRDTYPE) VALUES
(49,'PHP','7841','20040101','PHP','BAXTER BENTLEY
(EDWARDS)','SMITHED','A','19950313','TPR');
INSERT INTO INVTBLS.INVTBLS_DEL
(PKEY,ENTITYCODE,DEPTNUM,LASTCHGDATE,LOCATNDESCR,LOCATNNAME,OPERTRID,REC
RDSTATUSCODE,RECRDSTATUSDATE,RECRDTYPE) VALUES
(50,'PHP','6875','20040101','PHP','BAXTER
WHATEVER','SMITHED','A','19950313','TPR');

INSERT INTO VENDMSTR.VENDMSTR_VNM
(PKEY,VENDORNUM,VENDORNAME,RECRDSTATUSCODE,RECRDTYPE,RECRDSTATUSDATE)
VALUES (6312,'6174','CONCORD LABORATORIES, INC.','A','SPC','19881026');
INSERT INTO VENDMSTR.VENDMSTR_VNM
(PKEY,VENDORNUM,VENDORNAME,RECRDSTATUSCODE,RECRDTYPE,RECRDSTATUSDATE)
VALUES (21375,'17049','WELTY WELDING','A','SPC','19920210');
INSERT INTO VENDMSTR.VENDMSTR_VNM
(PKEY,VENDORNUM,VENDORNAME,RECRDSTATUSCODE,RECRDTYPE,RECRDSTATUSDATE)
VALUES (21394,'17060','COMPUTER CONSULTING','A','SPC','19930728');
INSERT INTO VENDMSTR.VENDMSTR_VNM
(PKEY,VENDORNUM,VENDORNAME,RECRDSTATUSCODE,RECRDTYPE,RECRDSTATUSDATE)
VALUES (21401,'17065','TEST VENDOR #4','A','SPC','20000523');
INSERT INTO VENDMSTR.VENDMSTR_VNM
(PKEY,VENDORNUM,VENDORNAME,RECRDSTATUSCODE,RECRDTYPE,RECRDSTATUSDATE)
VALUES (41019,'17105','KASEY','A','SPC','20040310');
INSERT INTO VENDMSTR.VENDMSTR_VNM
(PKEY,VENDORNUM,VENDORNAME,RECRDSTATUSCODE,RECRDTYPE,RECRDSTATUSDATE)
VALUES (41035,'98367','LADAY GROUP, THE','A','VNM','20050802');
INSERT INTO VENDMSTR.VENDMSTR_VNM
(PKEY,VENDORNUM,VENDORNAME,RECRDSTATUSCODE,RECRDTYPE,RECRDSTATUSDATE)
VALUES (41039,'88656','HOTLINK MARKETING, HOTLINK
INC','A','VNM','20020910');
INSERT INTO VENDMSTR.VENDMSTR_VNM
(PKEY,VENDORNUM,VENDORNAME,RECRDSTATUSCODE,RECRDTYPE,RECRDSTATUSDATE)
VALUES (41044,'60790','SOFTWARE HOUSE INTERNATIONAL
I','A','VNM','19980310');
INSERT INTO VENDMSTR.VENDMSTR_VNM
(PKEY,VENDORNUM,VENDORNAME,RECRDSTATUSCODE,RECRDTYPE,RECRDSTATUSDATE)
VALUES (41069,'49865','U.S. FOODSERVICE INC','A','VNM','19960717');
INSERT INTO VENDMSTR.VENDMSTR_VNM
(PKEY,VENDORNUM,VENDORNAME,RECRDSTATUSCODE,RECRDTYPE,RECRDSTATUSDATE)
VALUES (41078,'17109','KEN TEST VENDOR','A','VNM','20060509');


-----Original Message-----
From: Robert Manning [mailto:rob...@gm...]=20
Sent: Monday, December 04, 2006 4:12 PM
To: Savoy, Melinda
Cc: squ...@li...
Subject: Re: [Squirrel-sql-users] MySql

On 12/4/06, Savoy, Melinda <Mel...@te...> wrote:
>
>
>
> I am using MySql 5.0 and I connected to this database via Squirrel=20
> SQL.  I have multiple schemas/databases under my localhost.  However,=20
> when I try and run a .sql script that drops tables from multiple=20
> schemas & then populates them in the various schemas  I run into an=20
> error saying that it does not recognize the first schema name to drop=20
> the table.  I can run this thru MySQL but not through Squirrel and it
would be great if I could.

As long as in each statement you qualify the table name with the schema
it shouldn't be a problem.  I'm using 5.0.22 and I can create and drop
tables in schemas other than the one I connected to (<dbname> in url
jdbc:mysql://localhost:3306/<dbname>).  Note: there is ongoing
consideration being given to the fact that only one catalog's tables
(catalog is really the term for schema in MySQL) can be accessed in the
object tree based on the catalog selected in the catalog selector at the
top of the session window.

Rob




The information contained in this message and any attachments is intended=
 only for the use of the individual or entity to which it is addressed, a=
nd may contain information that is PRIVILEGED, CONFIDENTIAL, and exempt f=
rom disclosure under applicable law.  If you are not the intended recipie=
nt, you are prohibited from copying, distributing, or using the informati=
on.  Please contact the sender immediately by return e-mail and delete th=
e original message from your system.

Re: [Squirrel-sql-users] MySql

[Robert M. <rob...@gm...>]

On 12/4/06, Savoy, Melinda <Mel...@te...> wrote:
>
>
>
> I am using MySql 5.0 and I connected to this database via Squirrel SQL.  I
> have multiple schemas/databases under my localhost.  However, when I try and
> run a .sql script that drops tables from multiple schemas & then populates
> them in the various schemas  I run into an error saying that it does not
> recognize the first schema name to drop the table.  I can run this thru
> MySQL but not through Squirrel and it would be great if I could.

As long as in each statement you qualify the table name with the
schema it shouldn't be a problem.  I'm using 5.0.22 and I can create
and drop tables in schemas other than the one I connected to (<dbname>
in url jdbc:mysql://localhost:3306/<dbname>).  Note: there is ongoing
consideration being given to the fact that only one catalog's tables
(catalog is really the term for schema in MySQL) can be accessed in
the object tree based on the catalog selected in the catalog selector
at the top of the session window.

Rob

Re: [Squirrel-sql-users] Setting up DB2 configuration giving problems

[Sharma, A. <Ash...@gs...>]

Thanks that was really helpful-I can set it up.
Thanks a ton!!!=20

-----Original Message-----
From: Robert Manning [mailto:rob...@gm...]=20
Sent: Monday, December 04, 2006 4:42 PM
To: Sharma, Ashutosh
Cc: SQuirreL Users List
Subject: Re: [Squirrel-sql-users] Setting up DB2 configuration giving
problems

On 12/4/06, Sharma, Ashutosh <Ash...@gs...> wrote:
>  Directory of C:\Program Files\SQuirreL SQL Client\lib
>
> 12/04/2006  12:08 PM    <DIR>          .
> 12/04/2006  12:08 PM    <DIR>          ..
> 11/09/2006  04:33 PM            30,117 commons-cli.jar
> 12/04/2006  11:23 AM           236,997 db2fs.jar
> 04/16/2001  05:27 PM         1,136,282 db2java.zip
> 12/04/2006  11:23 AM         1,124,512 db2jcc.jar
> 12/04/2006  11:23 AM            23,709 db2jcc_javax.jar
> 12/04/2006  11:23 AM             2,063 db2jcc_license_cisuz.jar
> 12/04/2006  11:23 AM             1,013 db2jcc_license_cu.jar
> 12/04/2006  11:23 AM           118,928 db2policy.jar
> 12/04/2006  11:23 AM           229,041 db2qgjava.jar
> 11/09/2006  04:33 PM            75,370 forms.jar
> 11/09/2006  04:33 PM         1,327,905 fw.jar
> 11/09/2006  04:33 PM           223,469 log4j.jar
> 11/09/2006  04:33 PM            38,698 nanoxml-2.1.jar
>               13 File(s)      4,568,104 bytes
>                2 Dir(s)   5,536,415,744 bytes free
> db2fs.jar, db2jcc.jar, db2jcc_javax.jar, db2jcc_license_cisuz.jar,
> db2jcc_license_cu.jar, db2policy.jar, db2qgjava.jar
> Doesn't work when I put under lib dir.
> Only when I put sqljava.zip-then it recongnizes it as IBM Net App
> Driver-otherwise nothing happens.
> Can u tell me-which one is the DB2 driver out of it and then how to
> configure it.

I would not recommend copying all of your jdbc driver files into
SQuirreL's lib directory.  While it should work just fine, it can
cause delays in certain areas of the app and isn't very easily
upgradeable (assuming you put the new version down in a separate
directory which is just good practice to avoid stale files).  However,
I'm not sure why it would cause your driver not to be recognized.

If you modify the driver definition there is an 'Extra Classpath' tab
that will allow you to point to the two files I mentioned previously
(db2cc.jar and db2cc_license_cu.jar).  Those two jar files are
required.  When you add them using the 'Extra Classpath' tab you
should then click the button labelled 'List Drivers'.  You should then
choose the option in the Class Name drop-down list labelled
'com.ibm.db2.jcc.DB2Driver'. Click OK button then you should see a
message stating that the driver was successfully registered.  Let us
know how it goes.

Rob

Re: [Squirrel-sql-users] Setting up DB2 configuration giving problems

[Robert M. <rob...@gm...>]

On 12/4/06, Sharma, Ashutosh <Ash...@gs...> wrote:
>  Directory of C:\Program Files\SQuirreL SQL Client\lib
>
> 12/04/2006  12:08 PM    <DIR>          .
> 12/04/2006  12:08 PM    <DIR>          ..
> 11/09/2006  04:33 PM            30,117 commons-cli.jar
> 12/04/2006  11:23 AM           236,997 db2fs.jar
> 04/16/2001  05:27 PM         1,136,282 db2java.zip
> 12/04/2006  11:23 AM         1,124,512 db2jcc.jar
> 12/04/2006  11:23 AM            23,709 db2jcc_javax.jar
> 12/04/2006  11:23 AM             2,063 db2jcc_license_cisuz.jar
> 12/04/2006  11:23 AM             1,013 db2jcc_license_cu.jar
> 12/04/2006  11:23 AM           118,928 db2policy.jar
> 12/04/2006  11:23 AM           229,041 db2qgjava.jar
> 11/09/2006  04:33 PM            75,370 forms.jar
> 11/09/2006  04:33 PM         1,327,905 fw.jar
> 11/09/2006  04:33 PM           223,469 log4j.jar
> 11/09/2006  04:33 PM            38,698 nanoxml-2.1.jar
>               13 File(s)      4,568,104 bytes
>                2 Dir(s)   5,536,415,744 bytes free
> db2fs.jar, db2jcc.jar, db2jcc_javax.jar, db2jcc_license_cisuz.jar,
> db2jcc_license_cu.jar, db2policy.jar, db2qgjava.jar
> Doesn't work when I put under lib dir.
> Only when I put sqljava.zip-then it recongnizes it as IBM Net App
> Driver-otherwise nothing happens.
> Can u tell me-which one is the DB2 driver out of it and then how to
> configure it.

I would not recommend copying all of your jdbc driver files into
SQuirreL's lib directory.  While it should work just fine, it can
cause delays in certain areas of the app and isn't very easily
upgradeable (assuming you put the new version down in a separate
directory which is just good practice to avoid stale files).  However,
I'm not sure why it would cause your driver not to be recognized.

If you modify the driver definition there is an 'Extra Classpath' tab
that will allow you to point to the two files I mentioned previously
(db2cc.jar and db2cc_license_cu.jar).  Those two jar files are
required.  When you add them using the 'Extra Classpath' tab you
should then click the button labelled 'List Drivers'.  You should then
choose the option in the Class Name drop-down list labelled
'com.ibm.db2.jcc.DB2Driver'. Click OK button then you should see a
message stating that the driver was successfully registered.  Let us
know how it goes.

Rob

Re: [Squirrel-sql-users] Question about Abreviations

[Gerd W. <bir...@t-...>]

Fatbob wrote:
> Hi!
> 
> Is it possible to have a carriage return (or line feed) in Abreviations?
> 
> For example, typing sf gives us...
> 
> SELECT * FROM
> 
> can we have it do this instead...
> 
> SELECT *
> FROM
> 
Is available in CSV. Will be in next weekly build. See change log for details:

http://squirrel-sql.cvs.sourceforge.net/*checkout*/squirrel-sql/sql12/doc/changes.txt

Gerd


> Thanks!
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
> 

[Squirrel-sql-users] MySql

[Savoy, M. <Mel...@te...>]

I am using MySql 5.0 and I connected to this database via Squirrel SQL.
I have multiple schemas/databases under my localhost.  However, when I
try and run a .sql script that drops tables from multiple schemas & then
populates them in the various schemas  I run into an error saying that
it does not recognize the first schema name to drop the table.  I can
run this thru MySQL but not through Squirrel and it would be great if I
could.

Any suggestions? =20



Melinda Savoy
Sr. Programmer Analyst
Financial Applications - Enterprise Systems



The information contained in this message and any attachments is intended=
 only for the use of the individual or entity to which it is addressed, a=
nd may contain information that is PRIVILEGED, CONFIDENTIAL, and exempt f=
rom disclosure under applicable law.  If you are not the intended recipie=
nt, you are prohibited from copying, distributing, or using the informati=
on.  Please contact the sender immediately by return e-mail and delete th=
e original message from your system.

[Squirrel-sql-users] Setting up DB2 configuration giving problems

[Sharma, A. <Ash...@gs...>]

Hi,
I have installed version 2.3.1 of Squirrel SQL.
Trying to configure UDB DB2 database.
I have already put the sqljava.zip into lib directory and I m seeing the
listing as IBM DB2 Net Driver.
What shud be my URL entry when I can connect using java code as :
DriverManager.getConnection("jdbc:db2://titan.ny.imd.gs.com:61500/MSGCNT
R", "user", "password");=20

In my case the dialog keep on trying to connect but no success.

[Squirrel-sql-users] Question about Abreviations

[Fatbob <fat...@ho...>]

Hi!

Is it possible to have a carriage return (or line feed) in Abreviations?

For example, typing sf gives us...

SELECT * FROM

can we have it do this instead...

SELECT *
FROM

Thanks!

Re: [Squirrel-sql-users] Just getting started

[Robert M. <rob...@gm...>]

On 12/1/06, Bill Slack <ws...@sh...> wrote:
>
>
> I am just looking over Squirrel for the first time.
> I am working with Netbeans and javaDB (Derby).
> I created a database (pre Squirrel installation) with Netbeans, which runs
> fine.
> After successfully installing Squirrel, I created an alias to the database
> and  connected OK using the alias.
> The problem is that Squirrel won't connect to javaDB "after" I have made a
> connection from Netbeans again.
> But if I start javaDB with Netbeans and then try to make a connection with
> Sqirrel, everything is OK.

Bill,

What is the jdbc url that you use from SQuirreL to connect and how do
you start the database?  I start mine up in "Network Server" mode
using startNetworkServer.bat
(comes with Derby) and then use the following url to connect:

jdbc:derby://localhost:1527/<databasename>

Is it possible that you are running the DB in the same JVM as SQuirreL
(embedded) but with NetBeans it is starting it in "server" mode?  I
don't know much about the JavaDB that is provided with NetBeans and
how it is started, but my guess would be that it's running in embedded
mode in SQuirreL (only when NetBeans hasn't already started it)

Rob

[Squirrel-sql-users] Just getting started

[Bill S. <ws...@sh...>]

I am just looking over Squirrel for the first time.
I am working with Netbeans and javaDB (Derby).
I created a database (pre Squirrel installation) with Netbeans, which =
runs fine.
After successfully installing Squirrel, I created an alias to the =
database and  connected OK using the alias.
The problem is that Squirrel won't connect to javaDB "after" I have made =
a connection from Netbeans again.
But if I start javaDB with Netbeans and then try to make a connection =
with Sqirrel, everything is OK.

Is this usual behaviour?

Thanks,
Bill