DSXchange

The index believes that that value exists. Maybe you need to verify - even to re-build the index. Get your DBA involved.

"Step by step answers" falls into the realm of (paid) consulting. That's not really the niche that DSXchange fills. And I disagree about your "waste talk" point; we agreed that it was a pivot that you require, and took a couple of posts establishing the correct terminology so tha...

mayura wrote:Hi,
Please let me know the command to view the routine in datastage admin command line.

thanks,
Datastagepx

Why?

The routine source code is stored in a database table. It is not one of the fields displayed by SELECT * FROM DS_ROUTINES; query.

What do you actually need to achieve?

I'm not aware of one, and you're not the first to ask. Perhaps an enhancement request is in order?

Thank you for that. It's definitely a second scenario situation.

Investigation continues...

(There is strong corporate resistance to Ernie's suggestion. They expect the product to work out of the box as advertised, despite their unusual network configuration.)

datastagedw wrote:I have the following requirement:
...
please let me know if any other information is required

Why?

What is it meant to achieve?

A list of constant values in a SELECT statement will generate those constants for every row selected.

Put all mixed case column names in double quotes.

Welcome aboard.

Open the manuals (Start > All Programs > Information Server > Documentation) and scroll down to "Connectivity Guide for Microsoft SQL Server and OLE DB Data"

DSFindFirstLogEntry() ? This is a new one to me.

No mention in there of expiry date. Can you find the licensing XML file?

Because the data type is Char(3) so the lookup value is being padded. You are padding one with space, the other is being padded with $APT_STRING_PADCHAR (probably 0x00).

That's a good question, and I don't know the answer. Can you get to the operating system, attach to the DataStage engine directory, execute the dsenv script, and then issue a bin/dssh command?

Horizontal = columns to rows
Vertical = rows to columns

Then search on vertical pivot, for it's really that that you are trying to accomplish.

Did you install using a temporary license that has now expired?