Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2012
    Posts
    2

    Unanswered: Error code while inserting in to table.

    Hi All,
    I am working on IBM BPM V 7.5.1 and trying to insert data(currentdate) in to the table from an activity.But i am getting an error.please help me in this regard.

    The Error code i get is,
    SQLCODE=-104, SQLSTATE=42601

    code snippet in Authoring Env:

    tw.local.date=new TWDate();
    tw.local.stemp= tw.local.date.formatDateTime("MON DD,YYYY", "24HH:MMS");
    tw.local.sql="INSERT INTO DEVELOPMENT (CURRENTDATE) VALUES ("+tw.local.stemp+")".

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Date literals should be surrounded by single quotation marks. However, the format you're specifying will be invalid anyway.
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Oct 2012
    Posts
    2

    Question Error in SQL call

    Hi, Can you please suggest me some options to go ahead.I am able to insert data using the same query in to a table directly from a DB Query console.But i am having issues while running this query from IBM BPM IDE.

    What are the preffered functions to convert a Date to a Timestamp with format.Please suggest any links are inputs if any.

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Constants

    Look for "datetime constants".
    ---
    "It does not work" is not a valid problem statement.

Tags for this Thread

Posting Permissions

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