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
Question on User Defined-SQL
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
-----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
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
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