DSXchange

ray.wurlod

Top left of page, "Post new topic". Make sure you are in the appropriate forum first.

ray.wurlod

I did.

command1 && command2

What could be simpler?

Craig's solution would depend on which shell script language you are using. Maybe

Code: Select all

command1
if [ $? -eq 0 ] 
   command2
fi

ray.wurlod

Convert the timestamp to a string prior to aggregation and back again afterwards.

ray.wurlod

pradkumar wrote:Do we need to source dsenv everytime when we want to run the jobs from command line??

Yes.
Put the relevant commands into your login script (for example .profile).

ray.wurlod

To execute command2 only when command1 has executed successfully use the && connector.

Code: Select all

command1 && command2

ray.wurlod

Please post these questions about &PH& in a separate thread.

ray.wurlod

I've heard that it's planned, but no-one has committed to a date.

ray.wurlod

Get the null handling right. Then tell us where the VarChar is in your job design that is generating the message in your original post.

ray.wurlod

This question is not related to the subject of this thread. Please begin a new thread.

ray.wurlod

That might be possible, but only if your server and client are on the same machine, which is not often the case in production environments.

ray.wurlod

Could you do a column analysis on 16 million records any faster with your quill and parchment?

Did you profile the CSV file or the DB2 table?

ray.wurlod

To convert dynamic to static hashed use

Code: Select all

RESIZE name 18 * *

when you have exclusive access.

You can resize RT_LOGnnn, RT_CONFIGnnn, RT_STATUSnnn and DS_TEMPnnn (which are dynamic hashed files).

You can not resize RT_BPnnn or RT_BPnnn.O (which are regular directories).

ray.wurlod

The SQL statements are link properties. Therefore a query against DS_JOBOBJECTS where OLETYPE is like '%Input' or '%Output' would do it. I'd have to research the field numbers where the SQL is stored. There are at least three.

ray.wurlod

For "normalize on" to be enabled you need one or more fields defined as being able to handle multi-valued data. There is a check box in the table definition in the Repository that allows you to indicate support for multi-valued fields. When this is selected the Columns grid includes three new column...

ray.wurlod

Could it be something to do with (a) the user ID (and permissions), (b) quote characters (which DataStage might be stripping) or (c) environment variables?

Search found 53125 matches