DSXchange

When importing metadata either through Data Stage Designer or Data Stage Manager, you are required to select "Import", then select the type of file metadata that you want to import such as "Sequential, Plug-In" ODBC, etc". A few suggestions that would greatly (IMHO) increase...

The dssendmail_template.txt template is found under:

/opt/Ascential/DataStage/Projects/"your project name"

Thanks to all for replying
Dean

Craig,

Thanks. yes this is what I was thinking of. I thought I was dreaming.

Thanks
Dean

Thanks for the information. Where is the dssendmail_template.txt file found?

Dean

Greetings,

I am looking for a default screen in Data Stage Administrator or Data Stage Manager that allows me to set the SMTP mail settings for all DS jobs. I remember seeing it (I thought in DS Manager) a few weeks ago, but cannot find it now. Can anyone help me with this?

Thanks
Dean

Greetings, I have a server job that takes a source moves it through a transformer stage to perform 2 lookups to a hash files then writes it to a source. Simple. This is called from a job sequence. Within this server job, I have placed a 2 sequential files under the transformer stage to catch any rec...

Well, I finally solved the problem after much fumbling around. It turns out that using Data Stage, DB2 does not want the date in a normal date format such as YYYY-MM-DD (2005-07-27). It actually wants the ICONV value of the date. When we first encountered the problem, a logical first step was to man...

I think the problem is related to the date being a string and DB2 wanting a data format. I get the following error: LoadDateDimension..XfrmDate: At row 1, link "TBPTS01_DATE", while processing column "DATE_DT" Value treated as NULL Attempt to convert String value "2005-7-28&...

Greetings, I am trying to insert a value into a DB2 table that has a column property of DATE. I have reviewed all the posts on this message board and tried the ones that were appropriate but it continues to fail with a NULL error. I have tried to make this as basic as possible, by hardcoding the val...