DSXchange

Use the built in routine under

routines/sdk/RowProc/RowProcCompareWithPreviousValue

using this you can pick the first one and drop the rest

dont forget to sort data before doing this.

from command line use
"dssmtpmail"

dssmtpmail -server <smtp server ip address> -from xyz@abc.com -subject test -message c:\test\testmail.txt to@yahoo.com

kcbland wrote:The whole project only, but not specific categories. ...

Thanks everybody and a slight correction to what KC correct me if I am wrong.

The whole project for DSX or individual jobs for XML but nothing for category level backup

Guru's is it possible to do a command line export of the project or categories ?

What exactly are you trying to do ?

1. Try running your job with the "No Limit" option.

2. If the format of your date field is not in Oracle format simply reject the record before doing the lookup.

Hope that helps

Why dont you just multiply by 100 and write out to a CHAR field I assume what you want to do is


Look at the FMT function

This is what Ray was talking about http://www.dsxchange.com/viewtopic.php?t=87389 Thanks once again Ray Hi!Ray i didn't get - how can we see the "See new thread on capturing output of "UniVerse" commands".can yu be elaborate explicitly . Thanks and Regards Hemant See new thread o...

Which is a better way of doing it paragraph or using a routine ?

Ray how do you get those neat formating in your message

I need to drop 2 Universe Tables before the job runs I am trying to use the Before Job sub-routine set to "ExecTCL" and the input value as "DROP TABLE table1; DROP TABLE table2" as you can see the syntax is wrong please help me with the right one. Is there any better way of doing...

What is the configuration of your system ? Does it have enough resources

That's what I assumed to Hemant but I was wrong with my past experiences I was thinking this to be a diskspace/memory issue but what it turned out to be was that one of the derivation was turned to not null while the value going in was a NULL changing that fixed my problem and thanks to Ray for the ...

That worked great Ray. Thanks

I used the VLIST command on the DataStage Administrator Command Output Window is there any way to spool the output to a file or cut and paste.

When I run a job it Aborts with the following warning xGDW00MPRMatBillCost..AgGDWStandMatUsgVar: %s Abnormal termination of stage xGDW00MPRMatBillCost..XFmGDWValidateMatlPlant detected -------------------------------------------------------------------------------------------------------------------...

How do I find out the last update date time on a Hash File(Default Type30 Dynamic).

I am running DataStage 6 on Unix.

I tried looking for this in the forum didn't find anything.

Thanks in advance.
Ejaz

Caching Attribute is is an option that you have when you are creating the Hash File by default it is "NONE" but it can be "WRITE IMMEDIATE" OR "WRITE DEFFERRED"

Hope that helps