DSXchange

Is was-admin a Suite Administrator? To add/delete users you have to have the Suite Administrator role. Try logging in as isadmin (or whatever you have called your Suite Administrator).

Exactly that.

An absent TNS name would cause a compilation error.

I'd bet Char(8) - am I right? So you can only get eight characters in that field.

Execute $DSHOME/dsenv from wherever you are.

Change directory to the project directory.

From there execute $DSHOME/bin/dssh "SELECT * FROM DS_JOBS;"

What is your business rule for "last day of week"? In some countries weeks run from Sunday to Saturday, in other countries Monday to Sunday, etc. Without that knowledge no generic answer can be given.

Is there a UStringToDate() function? If so, use it. Otherwise use a message handler to demote the warning to informational.

There is a button in the server ODBC stage on the Stage properties tab, captioned "Get SQL quote character" or something similar. Clicking this button is all you need to do to load the quote character in the server ODBC stage. Make a note of that character and populate the Quote Character ...

Partition and sort your data with a Sort stage, generating a key change column. In a Transformer stage initialize a stage variable and use it

• to reset the count to 1 if the key change column is 1
  
  to increment the count if the key change column is 0

Next time you're discussing this with someone technical, the language to use is that "a modal dialog box opens but does not get focus".

A more tedious way to find the modal dialog box is to minimize every other window. "Show desktop" sometimes works, but not always.

Read the file as a single line (single VarChar) and use Field() function and constraint expressions in Transformer stage to parse records and filter by record type.

Please show result of

Only you can resolve the "issue". You have created user-defined SQL that does not use the same number of columns as in your metadata. In particular, if your SQL generates the key value (for example using a database sequence), then the key column should not appear in the metadata. The metad...

Yes, CPU=999 is the version 7 way of specifying "enterprise licence". Or, perhaps, you're using the wrong set of licence keys - you get one for your "proof of entitlement" and one real set. Check with your support provider that you're using the correct licences. Note that the mec...

I'm surprised that incrementing a VarChar works at all - after all there's no implicit conversion from string to any kind of numeric data type. Is the stage variable also VarChar? Are you using a stage type (such as Aggregator) that generates dfloat by default? Try defining this field as int32 (or u...