squirrel-sql-users

Re: [Squirrel-sql-users] Installing squirrel-sql-2.4 Exception Error

[Tyrone B. <tyr...@ho...>]

Install completed this morning.  I'm trying to get to set it up to use the 
database.  Now, I have this error but I think it is self explanatory.  
Really, I don't need the new version of this driver to work with the 
database.  Right?

JRE/JDBC Version Mismatch
The Driver being used for alias 'rbadb' is not JDBC 3.0 compliant.  You 
should consider getting a more recent version of this driver.


>From: "Robert Manning" <rob...@gm...>
>To: "Tyrone Baseck" <tyr...@ho...>
>CC: squ...@li...
>Subject: Re: [Squirrel-sql-users] Installing squirrel-sql-2.4 Exception 
>Error
>Date: Sun, 11 Mar 2007 20:27:47 -0500
>
>On 3/11/07, Tyrone Baseck <tyr...@ho...> wrote:
>>java version "1.3.1_04"
>>Java(TM) 2 Runtime Environment, Standard Edition (build 1.3.1_04-b02)
>>Java HotSpot(TM) Client VM (build 1.3.1_04-b02, mixed mode)
>
>You need to use a JVM that is at least 1.5 to run the installer and
>the 2.4.x series of SQuirreL.
>
>Rob

_________________________________________________________________
Rates near 39yr lows!  $430K Loan for $1,399/mo - Paying Too Much? Calculate 
new payment 
http://www.lowermybills.com/lre/index.jsp?sourceid=lmb-9632-18226&moid=7581

Re: [Squirrel-sql-users] Installing squirrel-sql-2.4 Exception Error

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

On 3/12/07, Tyrone Baseck <tyr...@ho...> wrote:
> Install completed this morning.  I'm trying to get to set it up to use the
> database.  Now, I have this error but I think it is self explanatory.
> Really, I don't need the new version of this driver to work with the
> database.  Right?
>
> JRE/JDBC Version Mismatch
> The Driver being used for alias 'rbadb' is not JDBC 3.0 compliant.  You
> should consider getting a more recent version of this driver.

That is correct.  You can disable this message by unchecking:

File -> Global Preferences -> General -> Warning for JRE/JDBC Version Mismatch

Unfortunately, it's not that unusual for a current JDBC driver
implementation to fail this check.  This doesn't mean that the driver
will present issues when used in SQuirreL.  It simply means that the
driver doesn't implement the same specification of JDBC that the JRE
supports.

Rob

Re: [Squirrel-sql-users] SQL 101

[Tyrone B. <tyr...@ho...>]

SELECT PERS_ROLE_HIST.ASGN_TS AS [Assignment Date], Trim(Pers.lst_nm)+" 
,"+Trim(pers.fst_nm) AS Name, DIV.DIV_NM AS Division, 
PERS_ROLE_HIST.AUTH_REQ_ID AS [Order #], ROLE.ROLE_CD, 
PERS_ROLE_HIST.ASGN_TS, PERS_ROLE_HIST.UNASGN_TS, PERS.TERM_DT, PERS.PERS_ID
FROM ROLE INNER JOIN ((PERS INNER JOIN DIV ON PERS.DIV_NBR = DIV.DIV_NBR) 
INNER JOIN PERS_ROLE_HIST ON PERS.PERS_ID = PERS_ROLE_HIST.PERS_ID) ON 
ROLE.ROLE_ID = PERS_ROLE_HIST.ROLE_ID
WHERE (((PERS.PERS_ID)=3321))
ORDER BY PERS_ROLE_HIST.ASGN_TS, Trim(Pers.lst_nm)+" ,"+Trim(pers.fst_nm);

I'm new.  Why am I receiving the following error?

Error: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/6000] SQL0104N  
An unexpected token "[Assignment Date]" was found following 
"ROLE_HIST.ASGN_TS AS".  Expected tokens may include:  "<space>".  
SQLSTATE=42601
, SQL State: 42601, Error Code: -104

_________________________________________________________________
Get a FREE Web site, company branded e-mail and more from Microsoft Office 
Live! http://clk.atdmt.com/MRT/go/mcrssaub0050001411mrt/direct/01/

Re: [Squirrel-sql-users] SQL 101

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

On 3/16/07, Tyrone Baseck <tyr...@ho...> wrote:
> SELECT PERS_ROLE_HIST.ASGN_TS AS [Assignment Date], Trim(Pers.lst_nm)+"
> ,"+Trim(pers.fst_nm) AS Name, DIV.DIV_NM AS Division,
> PERS_ROLE_HIST.AUTH_REQ_ID AS [Order #], ROLE.ROLE_CD,
> PERS_ROLE_HIST.ASGN_TS, PERS_ROLE_HIST.UNASGN_TS, PERS.TERM_DT, PERS.PERS_ID
> FROM ROLE INNER JOIN ((PERS INNER JOIN DIV ON PERS.DIV_NBR = DIV.DIV_NBR)
> INNER JOIN PERS_ROLE_HIST ON PERS.PERS_ID = PERS_ROLE_HIST.PERS_ID) ON
> ROLE.ROLE_ID = PERS_ROLE_HIST.ROLE_ID
> WHERE (((PERS.PERS_ID)=3321))
> ORDER BY PERS_ROLE_HIST.ASGN_TS, Trim(Pers.lst_nm)+" ,"+Trim(pers.fst_nm);
>
> I'm new.  Why am I receiving the following error?
>
> Error: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/6000] SQL0104N
> An unexpected token "[Assignment Date]" was found following
> "ROLE_HIST.ASGN_TS AS".  Expected tokens may include:  "<space>".
> SQLSTATE=42601
> , SQL State: 42601, Error Code: -104

Try quoting column aliases with quotes ("") instead of brackets ([])

Rob

Re: [Squirrel-sql-users] SQL 101

[Tyrone B. <tyr...@ho...>]

I will get help from the DBA on that query listed earlier.  The one listed 
below works.  Now, what is it doing:

select * from MGD_REQ_HOLDG m inner join AUTH_REQ_ITEM_HDR a on 
m.REQ_ITEM_HDR_ID = a.REQ_ITEM_HDR_ID
where a.auth_req_id

Do I need to change the MGD_REQ_HOLDG in the first line to look at another 
table?

What is the lower case "m" and "a" for?

Why do you need to add a "a" to a.REQ_ITEM_HDR_ID instead of doing it 
without the "a"?

Sorry... This is SQL for dummies questions.


>From: "Robert Manning" <rob...@gm...>
>To: "Tyrone Baseck" <tyr...@ho...>
>CC: squ...@li...
>Subject: Re: [Squirrel-sql-users] SQL 101
>Date: Sat, 17 Mar 2007 09:50:17 -0400
>
>On 3/16/07, Tyrone Baseck <tyr...@ho...> wrote:
>>SELECT PERS_ROLE_HIST.ASGN_TS AS [Assignment Date], Trim(Pers.lst_nm)+"
>>,"+Trim(pers.fst_nm) AS Name, DIV.DIV_NM AS Division,
>>PERS_ROLE_HIST.AUTH_REQ_ID AS [Order #], ROLE.ROLE_CD,
>>PERS_ROLE_HIST.ASGN_TS, PERS_ROLE_HIST.UNASGN_TS, PERS.TERM_DT, 
>>PERS.PERS_ID
>>FROM ROLE INNER JOIN ((PERS INNER JOIN DIV ON PERS.DIV_NBR = DIV.DIV_NBR)
>>INNER JOIN PERS_ROLE_HIST ON PERS.PERS_ID = PERS_ROLE_HIST.PERS_ID) ON
>>ROLE.ROLE_ID = PERS_ROLE_HIST.ROLE_ID
>>WHERE (((PERS.PERS_ID)=3321))
>>ORDER BY PERS_ROLE_HIST.ASGN_TS, Trim(Pers.lst_nm)+" ,"+Trim(pers.fst_nm);
>>
>>I'm new.  Why am I receiving the following error?
>>
>>Error: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/6000] SQL0104N
>>An unexpected token "[Assignment Date]" was found following
>>"ROLE_HIST.ASGN_TS AS".  Expected tokens may include:  "<space>".
>>SQLSTATE=42601
>>, SQL State: 42601, Error Code: -104
>
>Try quoting column aliases with quotes ("") instead of brackets ([])
>
>Rob

_________________________________________________________________
Exercise your brain! Try Flexicon. 
http://games.msn.com/en/flexicon/default.htm?icid=flexicon_hmemailtaglinemarch07

Re: [Squirrel-sql-users] SQL 101

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

On 3/20/07, Tyrone Baseck <tyr...@ho...> wrote:
> I will get help from the DBA on that query listed earlier.  The one listed
> below works.  Now, what is it doing:
>
> select * from MGD_REQ_HOLDG m inner join AUTH_REQ_ITEM_HDR a on
> m.REQ_ITEM_HDR_ID = a.REQ_ITEM_HDR_ID
> where a.auth_req_id
>
> Do I need to change the MGD_REQ_HOLDG in the first line to look at another
> table?

You are saying join tables MGD_REQ_HOLDG and AUTH_REQ_ITEM_HDR by
matching records where the field REQ_ITEM_HDR_ID in both tables is
equal.  If you need columns from other tables, then you would add them
to your join.  The where clause :

where a.auth_req_id

is incomplete.  You should give a value for auth_req_id like :

where a.auth_req_id = 42

or not include a where clause at all (which could be quite a large
number, depending on the data)

>
> What is the lower case "m" and "a" for?

Table aliases are more convenient than using the entire table name.

>
> Why do you need to add a "a" to a.REQ_ITEM_HDR_ID instead of doing it
> without the "a"?

Both tables apparently have a column called REQ_ITEM_HDR_ID, so the
database doesn't know which one you are referring to.  The table
aliases "m" and "a" tell it which one you mean.


Rob

Re: [Squirrel-sql-users] SQL 101

[Tyrone B. <tyr...@ho...>]

>From: "Robert Manning" <rob...@gm...>
>To: "Tyrone Baseck" <tyr...@ho...>
>CC: squ...@li...
>Subject: Re: [Squirrel-sql-users] SQL 101
>Date: Tue, 20 Mar 2007 17:40:42 -0400
>
>On 3/20/07, Tyrone Baseck <tyr...@ho...> wrote:
>>I will get help from the DBA on that query listed earlier.  The one listed
>>below works.  Now, what is it doing:
>>
>>select * from MGD_REQ_HOLDG m inner join AUTH_REQ_ITEM_HDR a on
>>m.REQ_ITEM_HDR_ID = a.REQ_ITEM_HDR_ID
>>where a.auth_req_id
>>
>>Do I need to change the MGD_REQ_HOLDG in the first line to look at another
>>table?
>
>You are saying join tables MGD_REQ_HOLDG and AUTH_REQ_ITEM_HDR by
>matching records where the field REQ_ITEM_HDR_ID in both tables is
>equal.  If you need columns from other tables, then you would add them
>to your join.  The where clause :
>
>where a.auth_req_id
>
>is incomplete.  You should give a value for auth_req_id like :
>
>where a.auth_req_id = 42
>
>or not include a where clause at all (which could be quite a large
>number, depending on the data)
>
>>
>>What is the lower case "m" and "a" for?
>
>Table aliases are more convenient than using the entire table name.
>
>>
>>Why do you need to add a "a" to a.REQ_ITEM_HDR_ID instead of doing it
>>without the "a"?
>
>Both tables apparently have a column called REQ_ITEM_HDR_ID, so the
>database doesn't know which one you are referring to.  The table
>aliases "m" and "a" tell it which one you mean.
>
>
>Rob

Oh!! So the a.REQ_ITEM_HDR_ID can be inputted as the following:  
AUTH_REQ_ITEM_HDR.REQ_ITEM_HDR_ID

No answer needed on that comment.

_________________________________________________________________
Exercise your brain! Try Flexicon. 
http://games.msn.com/en/flexicon/default.htm?icid=flexicon_hmemailtaglinemarch07