DSXchange

Posted: **Tue Oct 16, 2001 10:51 pm**

Hi All,

This is again a question on User defined SQL in an
OCIstage.

An example of the same:

"INSERT INTO TableX
(COL1,COL2,COL3,COL4) VALUES
(:1,:2,:3,:4)"

My Question is : Instead of the position specific bind variables in the VALUES clause, can we use named variables ? e.g.

"INSERT INTO TableX
(COL1,COL2,COL3,COL4) VALUES (:SrcCol1,:SrcCol2,:SrcCol3,:SrcCol4)"

Thanks,
Bibhu

__________________________________________________
Do You Yahoo!?
Make a great connection at Yahoo! Personals. http://personals.yahoo.com

Posted: **Tue Oct 16, 2001 11:04 pm**

Now thats an easy question. The simple answer is "no". (Unless someone added this without telling me).

-----Original Message-----
From: Bibhu C [mailto:bibhuds@yahoo.com]
Sent: Wednesday, 17 October 2001 8:52 AM
To: datastage-users@oliver.com
Subject: Question on User Defined-SQL

Hi All,

This is again a question on User defined SQL in an
OCIstage.

An example of the same:

"INSERT INTO TableX
(COL1,COL2,COL3,COL4) VALUES
(:1,:2,:3,:4)"

My Question is : Instead of the position specific bind variables in the VALUES clause, can we use named variables ? e.g.

"INSERT INTO TableX
(COL1,COL2,COL3,COL4) VALUES (:SrcCol1,:SrcCol2,:SrcCol3,:SrcCol4)"

Thanks,
Bibhu

__________________________________________________
Do You Yahoo!?
Make a great connection at Yahoo! Personals. http://personals.yahoo.com

Posted: **Wed Oct 17, 2001 5:43 pm**

David,

Many thanks ! Any thought on why they didnt want to do
have this lil feature ?

Regards
Bibhu

--- David Barham wrote:
> Now thats an easy question. The simple answer is
> "no". (Unless someone
> added this without telling me).
>
> -----Original Message-----
> From: Bibhu C [mailto:bibhuds@yahoo.com]
> Sent: Wednesday, 17 October 2001 8:52 AM
> To: datastage-users@oliver.com
> Subject: Question on User Defined-SQL
>
> Hi All,
>
> This is again a question on User defined SQL in an
> OCIstage.
>
> An example of the same:
>
> "INSERT INTO TableX
> (COL1,COL2,COL3,COL4) VALUES
> (:1,:2,:3,:4)"
>
> My Question is : Instead of the position specific
> bind
> variables in the VALUES clause, can we use named
> variables ? e.g.
>
> "INSERT INTO TableX
> (COL1,COL2,COL3,COL4) VALUES (:SrcCol1,:SrcCol2,:SrcCol3,:SrcCol4)"
>
> Thanks,
> Bibhu

__________________________________________________
Do You Yahoo!?
Make a great connection at Yahoo! Personals. http://personals.yahoo.com