SQLCommand, Select doing a join ...

2002-08-05
2002-08-05
  • Bertram Moshier

    Bertram Moshier - 2002-08-05

    I'm trying to use the rexx variables after:

    select ts.name, df.name
       from v$tablespace ts,
              v$datafile df
       where ts.ts# = df.ts#
           and ts.name = 'SYSTEM'

    I just can't figure out what the rexx array name will be.  I thought it would be:

    value(value(statementID.ts.name) and
    value(value(statementID.df.name)

    but those are null.

    I thank you in advance for your help!

     
    • Bertram Moshier

      Bertram Moshier - 2002-08-05

      I meant

      value(value(statementID).ts.name) and
      value(value(statementID).df.name)

      but those are uninitialized.

       
      • Bertram Moshier

        Bertram Moshier - 2002-08-05

        alias is the solution.

        Hey!  How many people are using REXX/SQL.  The forum doesn't seem very busy.

        select ts.name tsname, df.name dfname ....

        This should be in the docs, IMHO.

        Thanks for a product that does work (even if the documentation needs work)!

         

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks