Page 1 of 1

'no descriptor for this position'

Posted: Fri Mar 19, 2004 6:01 am
by admin
Hi All,

I get this error while trying to get the highest value of a number-field in
the Oracle table using max(name_of_the_field... any idea?

testJRNL..Oracle_OCI_9i_15: ORA-24334: no descriptor for this position
testJRNL..Oracle_OCI_9i_15.DSLink1: DSP.Open GCI $DSP.Open error -100.


Thanx!

Wim van Dommelen.


****************************DISCLAIMER***********************************
Deze e-mail is uitsluitend bestemd voor de geadresseerde(n). Verstrekking aan en gebruik door anderen is niet toegestaan. Fortis sluit iedere aansprakelijkheid uit die voortvloeit uit electronische verzending.

This e-mail is intended exclusively for the addressee(s), and may not be
passed on to, or made available for use by any person other than the
addressee(s). Fortis rules out any and every liability resulting from
any electronic transmission.
*******************************************************************************

_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users

'no descriptor for this position'

Posted: Fri Mar 19, 2004 6:16 am
by admin
Hi Wim,
If you have a Select Script like:
------------------------------------
create table John as
select
max(name)
from
Elleen;
-----------------------------------
you get this message.

You should then write:

create table John as
select
max(name) as Max_Name
>From
Elleen;

after a max(), sum().... etc you have to write a field name.

Have an nice day and a nice week-end.

Wolfgang


-----Original Message-----
From: Dommelen van W. (Wim) [mailto:Wim.van.Dommelen@NL.Fortis.com]
Sent: Friday, March 19, 2004 1:01 PM
To: 'DataStage Users Discussion List'
Subject: 'no descriptor for this position'


Hi All,

I get this error while trying to get the highest value of a number-field in
the Oracle table using max(name_of_the_field... any idea?

testJRNL..Oracle_OCI_9i_15: ORA-24334: no descriptor for this position
testJRNL..Oracle_OCI_9i_15.DSLink1: DSP.Open GCI $DSP.Open error -100.


Thanx!

Wim van Dommelen.


****************************DISCLAIMER***********************************
Deze e-mail is uitsluitend bestemd voor de geadresseerde(n). Verstrekking
aan en gebruik door anderen is niet toegestaan. Fortis sluit iedere
aansprakelijkheid uit die voortvloeit uit electronische verzending.

This e-mail is intended exclusively for the addressee(s), and may not be
passed on to, or made available for use by any person other than the
addressee(s). Fortis rules out any and every liability resulting from
any electronic transmission.
****************************************************************************
***

_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users
_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users

'no descriptor for this position'

Posted: Fri Mar 19, 2004 6:36 am
by admin
This means that the number of columns you have defined in the OCI Stage does
not match the number of parameter markers in your Custom SQL.

-craig

-----Original Message-----
From: datastage-users-bounces@oliver.com
[mailto:datastage-users-bounces@oliver.com] On Behalf Of Dommelen van W.
(Wim)
Sent: Friday, March 19, 2004 5:01 AM
To: 'DataStage Users Discussion List'
Subject: 'no descriptor for this position'


Hi All,

I get this error while trying to get the highest value of a number-field in
the Oracle table using max(name_of_the_field... any idea?

testJRNL..Oracle_OCI_9i_15: ORA-24334: no descriptor for this position
testJRNL..Oracle_OCI_9i_15.DSLink1: DSP.Open GCI $DSP.Open error -100.


Thanx!

Wim van Dommelen.

_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users