DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
admin
Site Admin



Joined: 12 Jan 2003
Posts: 8720

Points: 10

Post Posted: Tue Feb 24, 2004 5:49 pm Reply with quote    Back to top    

Hi,

When I tried using standard string functions in DS, some of them seems to work, but some don't.

For eg.

Alpha("hai") - works

AlNum("hai") - compile error with message:

Compiling: Source = 'DSU_BP/DSU.test2', Object = 'DSU_BP.O/DSU.test2'

Array 'AlNum' never dimensioned.

1 Errors detected, No Object Code Produced.


Any suggessions!

Thanks in advance

Bret




---------------------------------
Do you Yahoo!?
Yahoo! Mail SpamGuard - Read only the mail you want.
_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users

_________________
PLEASE READ
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
admin
Site Admin



Joined: 12 Jan 2003
Posts: 8720

Points: 10

Post Posted: Tue Feb 24, 2004 5:53 pm Reply with quote    Back to top    

I suspect you mean

Num("hai")


-----Original Message-----
From: Rocky Maviya [mailto:mail2rock2003@yahoo.com]
Sent: Wednesday, 25 February 2004 9:49 AM
To: DataStage Users Discussion List
Subject: Using functions


Hi,

When I tried using standard string functions in DS, some of them seems to work, but some don't.

For eg.

Alpha("hai") - works

AlNum("hai") - compile error with message:

Compiling: Source = 'DSU_BP/DSU.test2', Object = 'DSU_BP.O/DSU.test2'

Array 'AlNum' never dimensioned.

1 Errors detected, No Object Code Produced.


Any suggessions!

Thanks in advance

Bret




---------------------------------
Do you Yahoo!?
Yahoo! Mail SpamGuard - Read only the mail you want.
_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users




**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**********************************************************************

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

_________________
PLEASE READ
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Rate this response:  
Not yet rated
admin
Site Admin



Joined: 12 Jan 2003
Posts: 8720

Points: 10

Post Posted: Tue Feb 24, 2004 5:59 pm Reply with quote    Back to top    

No David, its ALNUM only. I have tried few string and date functions randomly, some of them seems to work properly, but others don't.



David.Barham@Anglocoal.com.au wrote:
I suspect you mean

Num("hai")


-----Original Message-----
From: Rocky Maviya [mailto:mail2rock2003@yahoo.com]
Sent: Wednesday, 25 February 2004 9:49 AM
To: DataStage Users Discussion List
Subject: Using functions


Hi,

When I tried using standard string functions in DS, some of them seems to work, but some don't.

For eg.

Alpha("hai") - works

AlNum("hai") - compile error with message:

Compiling: Source = 'DSU_BP/DSU.test2', Object = 'DSU_BP.O/DSU.test2'

Array 'AlNum' never dimensioned.

1 Errors detected, No Object Code Produced.


Any suggessions!

Thanks in advance

Bret




---------------------------------
Do you Yahoo!?
Yahoo! Mail SpamGuard - Read only the mail you want.
_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users




**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**********************************************************************

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

---------------------------------
Do you Yahoo!?
Yahoo! Mail SpamGuard - Read only the mail you want.
_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users

_________________
PLEASE READ
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Rate this response:  
Not yet rated
admin
Site Admin



Joined: 12 Jan 2003
Posts: 8720

Points: 10

Post Posted: Tue Feb 24, 2004 6:11 pm Reply with quote    Back to top    

OK, I'm a little confused.

I'm not familiar with AlNum - maybe it is a new function that we don't have in 5.2.

If you have tried a few functions and some work, some don't, where are you getting this list of functions that you are trying.

The error you are getting says that DataStage does not recognise that function name (and neither do I for that matter).

I'm assuming from the error message that you are using standard DataStage Server (not mainframe or PX or some other flavour).

Perhaps you can provide more information.


-----Original Message-----
From: Rocky Maviya [mailto:mail2rock2003@yahoo.com]
Sent: Wednesday, 25 February 2004 10:00 AM
To: DataStage Users Discussion List
Subject: RE: Using functions

No David, its ALNUM only. I have tried few string and date functions randomly, some of them seems to work properly, but others don't.



David.Barham@Anglocoal.com.au wrote:
I suspect you mean

Num("hai")


-----Original Message-----
From: Rocky Maviya [mailto:mail2rock2003@yahoo.com]
Sent: Wednesday, 25 February 2004 9:49 AM
To: DataStage Users Discussion List
Subject: Using functions


Hi,

When I tried using standard string functions in DS, some of them seems to work, but some don't.

For eg.

Alpha("hai") - works

AlNum("hai") - compile error with message:

Compiling: Source = 'DSU_BP/DSU.test2', Object = 'DSU_BP.O/DSU.test2'

Array 'AlNum' never dimensioned.

1 Errors detected, No Object Code Produced.


Any suggessions!

Thanks in advance

Bret




---------------------------------
Do you Yahoo!?
Yahoo! Mail SpamGuard - Read only the mail you want.
_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users




**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**********************************************************************

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

---------------------------------
Do you Yahoo!?
Yahoo! Mail SpamGuard - Read only the mail you want.
_______________________________________________
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

_________________
PLEASE READ
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Rate this response:  
Not yet rated
admin
Site Admin



Joined: 12 Jan 2003
Posts: 8720

Points: 10

Post Posted: Tue Feb 24, 2004 6:16 pm Reply with quote    Back to top    

There is no ALNUM in the Universe BASIC Guide or in the server job developers guide. If it is a routine that has been added to your project then you should execute it as DSU.ALNUM.

Call DSU.ALNUM(InputArg, ErrorCode)

> Vincent McBurney | Senior Consultant | BearingPoint
> Mobile: + 61 400 320 418 | Email: vincent.mcburney@bearingpoint.com
> www.bearingpoint.com


-----Original Message-----
From: datastage-users-bounces@oliver.com
[mailto:datastage-users-bounces@oliver.com]On Behalf Of
David.Barham@Anglocoal.com.au
Sent: Wednesday, 25 February 2004 11:11
To: datastage-users@oliver.com
Subject: RE: Using functions


OK, I'm a little confused.

I'm not familiar with AlNum - maybe it is a new function that we don't have in 5.2.

If you have tried a few functions and some work, some don't, where are you getting this list of functions that you are trying.

The error you are getting says that DataStage does not recognise that function name (and neither do I for that matter).

I'm assuming from the error message that you are using standard DataStage Server (not mainframe or PX or some other flavour).

Perhaps you can provide more information.


-----Original Message-----
From: Rocky Maviya [mailto:mail2rock2003@yahoo.com]
Sent: Wednesday, 25 February 2004 10:00 AM
To: DataStage Users Discussion List
Subject: RE: Using functions

No David, its ALNUM only. I have tried few string and date functions randomly, some of them seems to work properly, but others don't.



David.Barham@Anglocoal.com.au wrote:
I suspect you mean

Num("hai")


-----Original Message-----
From: Rocky Maviya [mailto:mail2rock2003@yahoo.com]
Sent: Wednesday, 25 February 2004 9:49 AM
To: DataStage Users Discussion List
Subject: Using functions


Hi,

When I tried using standard string functions in DS, some of them seems to work, but some don't.

For eg.

Alpha("hai") - works

AlNum("hai") - compile error with message:

Compiling: Source = 'DSU_BP/DSU.test2', Object = 'DSU_BP.O/DSU.test2'

Array 'AlNum' never dimensioned.

1 Errors detected, No Object Code Produced.


Any suggessions!

Thanks in advance

Bret




---------------------------------
Do you Yahoo!?
Yahoo! Mail SpamGuard - Read only the mail you want.
_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users




**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**********************************************************************

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

---------------------------------
Do you Yahoo!?
Yahoo! Mail SpamGuard - Read only the mail you want.
_______________________________________________
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

***************************************************************************************************
The information in this email is confidential and may be legally privileged. Access to this email by anyone other than the intended addressee is unauthorized. If you are not the intended recipient of this message, any review, disclosure, copying, distribution, retention, or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. If you are not the intended recipient, please reply to or forward a copy of this message to the sender and delete the message, any attachments, and any copies thereof from your system.
***************************************************************************************************
_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users

_________________
PLEASE READ
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Rate this response:  
Not yet rated
admin
Site Admin



Joined: 12 Jan 2003
Posts: 8720

Points: 10

Post Posted: Wed Feb 25, 2004 1:38 pm Reply with quote    Back to top    

The point is that there is no intrinsic function called ALNUM. This you can discover by checking on-line help, the DataStage BASIC manual, or signing up for Ascential's "Programming with DataStage BASIC" class.
You could write your own ALNUM function. This is what the compiler is looking for when it uses the DSU (DataStage User-written) prefix. However, it seems that you have not.

----- Original Message -----
From: Rocky Maviya
Date: Tue, 24 Feb 2004 15:59:38 -0800 (PST)
To: DataStage Users Discussion List
Subject: RE: Using functions

> No David, its ALNUM only. I have tried few string and date functions randomly, some of them seems to work properly, but others don't.
>
>
>
> David.Barham@Anglocoal.com.au wrote:
> I suspect you mean
>
> Num("hai")
>
>
> -----Original Message-----
> From: Rocky Maviya [mailto:mail2rock2003@yahoo.com]
> Sent: Wednesday, 25 February 2004 9:49 AM
> To: DataStage Users Discussion List
> Subject: Using functions
>
>
> Hi,
>
> When I tried using standard string functions in DS, some of them seems to work, but some don't.
>
> For eg.
>
> Alpha("hai") - works
>
> AlNum("hai") - compile error with message:
>
> Compiling: Source = 'DSU_BP/DSU.test2', Object = 'DSU_BP.O/DSU.test2'
>
> Array 'AlNum' never dimensioned.
>
> 1 Errors detected, No Object Code Produced.
>
>
> Any suggessions!
>
> Thanks in advance
>
> Bret
>
>
>
>
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Mail SpamGuard - Read only the mail you want.
> _______________________________________________
> datastage-users mailing list
> datastage-users@oliver.com
> http://www.oliver.com/mailman/listinfo/datastage-users
>
>
>
>
> **********************************************************************
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
>
> This footnote also confirms that this email message has been swept by
> MIMEsweeper for the presence of computer viruses.
>
> www.mimesweeper.com
> **********************************************************************
>
> _______________________________________________
> datastage-users mailing list
> datastage-users@oliver.com
> http://www.oliver.com/mailman/listinfo/datastage-users
>
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Mail SpamGuard - Read only the mail you want.
> _______________________________________________
> 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

_________________
PLEASE READ
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours