Dates (was - incorrectly - x$x variables)

[admin]

Use a correct combination of functions ICONV and OCONV.

Exacrly what is required depends on the stage type you are using to connect to the target table - for example and ODBC stage will require the date to conform to ODBC protocols, whereas a database-specific stage, for example ORAOCI, will require the date to conform to the date picture expected by that database server which may, in turn, depend on the setting of an environment variable or configuration setting in the database server.

Please ensure that your Subject is correct, so as to help future users browsing the archives.

----- Original Message -----
From: "Nibha Nanda"
Date: Thu, 15 Jan 2004 18:36:10 -0800
To:
Subject: Re: x$x variables

> 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
>

>
> DISCLAIMER: The information contained in this message is intended only and solely for the addressed individual or entity indicated in this message and for the exclusive use of the said addressed individual or entity indicated in this message (or responsible for delivery of the message to such person) and may contain legally privileged and confidential information belonging to Tata Consultancy Services. It must not be printed, read, copied, disclosed, forwarded, distributed or used (in whatsoever manner) by any person other than the addressee. Unauthorized use, disclosure or copying is strictly prohibited and may constitute unlawful act and can possibly attract legal action, civil and/or criminal. The contents of this message need not necessarily reflect or endorse the views of Tata Consultancy Services on any subject matter. Any action taken or omitted to be taken based on this message is entirely at your risk and neither the originator of this message nor Tata Consultancy
Se
> rvices takes any responsibility or liability towards the same. Opinions, conclusions and any other information contained in this message that do not relate to the official business of Tata Consultancy Services shall be understood as neither given nor endorsed by Tata Consultancy Services or any affiliate of Tata Consultancy Services. If you have received this message in error, you should destroy this message and may please notify the sender by e-mail. Thank you.
>