Results 1 to 1 of 1
  1. #1
    Join Date
    Jan 2010
    Posts
    207

    Unanswered: Use of a variable with Data Studio within a SQL Query on a DB2 z/OS database

    Hello friends,

    does anyone know how I can use a variable within my sql when I am connected with the Data Studio to my DB2 Database which is located on z/OS.

    Thank you for your help in advance.

    best regards,

    DB_N00B

    PS: This is my script


    D_SSY_TPR_TS1380_P.sql

    CREATE VARIABLE BLUB VARCHAR(10)
    SET BLUB = 'Y'
    SELECT *
    FROM TABLE
    where MANUAL_CREATION = BLUB


    Failed queries => 3
    Last edited by DB_N00b; 05-26-16 at 05:57.

Posting Permissions

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