May 24, 2005 at 7:21 am
I'm attempting to use the CREATE ALIAS command to access a specific file member and then use the SELECT command to access the "ALIAS". I'm getting an error stating that the SELECT keyword is not expected. <END-OF-STATEMENT> is necessary. Does anyone know how to break up these two commands? I'm guessing it's a delimiter that I'm missing. Any help is greatly appreciated. Thanks.
May 24, 2005 at 7:42 am
Can you post the statement and what you are trying to accomplish?
May 24, 2005 at 7:53 am
CREATE ALIAS QTEMP.GLJRN0502 FOR S2KPRDD.GLJRNLS(GLJRN0502)
SELECT * FROM QTEMP.GLJRN0502 WHERE (JNCO = '002') AND (JNDEPT = '531') ORDER BY JNMACT, JNSACT
From within SQL Server Reporting Services I'm accessing iSeries file which have multiple members. I'm attempting to access a specific member. SQL appears to be expecting something to break up the two commands.
May 24, 2005 at 7:59 am
I can't find anything on yahoo that would lead me to believe that this is possible. Nothing in books online either.
May 25, 2005 at 10:49 am
OK, I have almost zero iSeries experience, but I do have experience using DTS to access an Ingres on SCO DB. Your syntax in and of itself isn't Transact-SQL compatible, ALIAS is used in other ways on the MS side (unless I'm missing something). Is this a live connection for real-time querying? We used DTS to suck over the data set then manipulated it as a 20 minute lag for our app was perfectly acceptable, obviously that's not viable for big or real-time systems.
If it's real-time, you might do better approaching an iSeries forum. There are a few people here who are iSeries savvy, you might want to search forums for their names and email them directly.
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply