Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2003
    Posts
    3

    Unanswered: Recognized functions for PS/Query

    I am working with PeopleSoft on a Microsoft SQL platform. Does anyone know where I can get a list of the recognized functions for PS/Query expressions?

    i.e. convert(char(12), A.ACCOUNTING_DT, 101)
    datediff(yy, A.ACCOUNTING_DT, getdate()) etc.

    Thanks for your help!

    Kim

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    A list of functions?

    BOL

    A list of functions used by PS?

    Script the database...happy reading...

    Actually I would take the DDL and insert into a table with 1 column that is varchar(8000) and bcp/ dts or bulk insert the ddl in there, and the query the table...

    Is that what you're asking?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Dec 2003
    Posts
    3
    PS/Query allows you to build Ad hoc queries. You can create and run queries to retrieve data from the database on the spot, without writing SQL code. It makes it easy for our non-programming users to create the queries they need.

    It has the capability of creating expressions with an expression editor, but no where in the documentation does it list any of the recognized functions. The ones I currently use have been developed by trial and error.

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Doesn't PS use SQR?

    And the function would still have to be SQL Server complaint..no?

    http://msdn.microsoft.com/library/de...start_4fht.asp
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •