DSXchange

Note too that dsenv requires Bourne shell convention; you cannot set an environment value within the context of an export command. These must be separate steps.

I don't often disagree with Andy, but this time alas I do. He's correct to say that orchadmin -s will display the schema of the Data Set, but incorrect to assume that it will create a DataStage table definition from that schema.

I'm not aware of any command line mechanism for doing this.

You might be able to use the Web Services Transformer stage to return what's at that URL, particularly if it exposes a web service.

The important piece of information here is that you use the stage variable in a Constraint expression, so that no rows are transferred to output once your break condition has been met.

May I suggest a server job to retrieve the list, which you can park in the job's user status area and retrieve through the $UserStatus activity variable downstream of that job in its controlling sequence?

When you say "large" rows, do you mean "wide" rows (many columns) or large number of rows? It is a fundamental requirement for the Lookup stage that the whole volume of reference data must be able to be loaded into memory. Therefore you should avoid selecting any rows that you wi...

Have you made this message handler the default for the whole project (using the Administrator client)? If you have, it will continue to be used unless you explicitly disable message handling when submitting the job run request.

"Table or view not found" is nothing at all to do with the table definitions. It is about incorrectly qualified table/view names, possibly caused by the table or view not being in the connecting user's default schema.

ssnegi wrote:StringToDate(Inputlink.colname[1,4]:'-':Inputlink.colname[5,2]:'-':Inputlink.colname[7,2],"%yyyy-%mm-%dd")

This is working correctly for me. Check the data to see if there are any errors like nulls, wrong format etc

That won't work for "2012/3/11".

What's different about your machine? Was the installation successful? What does Version.xml tell you? Can you see jobs in Director client? What happens if you open Designer from Director client Tools menu?

Is version 8.1 supported on 64-bit SuSe ?

It's all sessions.

You also have the ability to "quiesce" Information Server, which still allows administrators to log in.

Date data types are stored in a binary form, so do not have formats. To convert from one string representation to another, convert to and from Date data type with appropriate format strings. That is, use StringToDate() and DateToString() functions, assuming you're using a Transformer stage. Or date_...

Where exactly are you trying to do this?

If you're trying to use a job parameter, you must select it using the expression editor - for some reason typing it in is not recognized.

No using dscmdexport. However, the istool command gives you this functionality.