x$x variables

[admin]

Your DataStage BASIC manual informs you that legal characters in variable names are alphanumerics (A-Z, a-z and 0-9), dollar signs ($), period (.) and percent sign (%) and perhaps, depending on your version, underscore (_).
Technically, therefore, there's no difference.
You will find that the percent sign (%) is used a lot in code generated by DataStage itself and dollar sign is used particularly as a separator character in constants (for example FINFO$FILEINODE).
But, to answer your question, the dollar sign is simply one of the characters that is legal in a variable name. It has no special significance.

----- Original Message -----
From: "Alex Martins"
Date: Tue, 13 Jan 2004 17:03:15 -0200
To: "Datastage-Users (E-mail)"
Subject: x$x variables

> Misters,
> what difference does it make when a variable has a '$' in its name?
> Tks,
> Alex

[admin]

----- Original Message -----
From: "Ray Wurlod"
To:
Sent: Tuesday, January 13, 2004 12:03 PM
Subject: Re: x$x variables


> Your DataStage BASIC manual informs you that legal characters in variable
names are alphanumerics (A-Z, a-z and 0-9), dollar signs ($), period (.) and
percent sign (%) and perhaps, depending on your version, underscore (_).
> Technically, therefore, there's no difference.
> You will find that the percent sign (%) is used a lot in code generated by
DataStage itself and dollar sign is used particularly as a separator
character in constants (for example FINFO$FILEINODE).
> But, to answer your question, the dollar sign is simply one of the
characters that is legal in a variable name. It has no special
significance.
>
> ----- Original Message -----
> From: "Alex Martins"
> Date: Tue, 13 Jan 2004 17:03:15 -0200
> To: "Datastage-Users (E-mail)"
> Subject: x$x variables
>
> > Misters,
> > what difference does it make when a variable has a '$' in its name?
> > Tks,
> > Alex

[admin]

Hi all
In a transformer one of the field value is a result of oconv function.
The target table is a date field with 'YYYY-MM-DD' format. The error we are
getting is unable to convert a string to a date in the transformer. Please
can you suggest a method in datastage to convert a string to a date in
server job.

Thanks
Nibha
----- Original Message -----
From: "Ray Wurlod"
To:
Sent: Tuesday, January 13, 2004 12:03 PM
Subject: Re: x$x variables


> Your DataStage BASIC manual informs you that legal characters in variable
names are alphanumerics (A-Z, a-z and 0-9), dollar signs ($), period (.) and
percent sign (%) and perhaps, depending on your version, underscore (_).
> Technically, therefore, there's no difference.
> You will find that the percent sign (%) is used a lot in code generated by
DataStage itself and dollar sign is used particularly as a separator
character in constants (for example FINFO$FILEINODE).
> But, to answer your question, the dollar sign is simply one of the
characters that is legal in a variable name. It has no special
significance.
>
> ----- Original Message -----
> From: "Alex Martins"
> Date: Tue, 13 Jan 2004 17:03:15 -0200
> To: "Datastage-Users (E-mail)"
> Subject: x$x variables
>
> > Misters,
> > what difference does it make when a variable has a '$' in its name?
> > Tks,
> > Alex