DSXchange

I did not get that. You can use group by or you cannot. You can do the counts in transformer using stage varialbes. Discussed zillions of times. Search is your best friend
Like this for example.

kaps wrote:It works...But looks like I am stating the samething twice...Is this the correct approach ?

Thanks

That "No. You are not" was for the above quest of yours. You are fine.

Are you referring to DSParam file. Its present in the your project directory.

What do you mean by size of ETL? If you mean size of a project then you can do df -k to utilize how many bytes are being used up by what parent directory. You can also check for size by doing ANALYZE.FILE RT_LOGxxx where xxx is the job id.

Nop. You are not. You are aborting the sequence job when you encounter a warning in your routine. Arg1 can be anything. Its a log entry from your end.

ICONV/OCONV wont work in a px transformer. It will in a basic transformer. You need to give only the date part. Use ICONV(FIELD(in.col," ",1),"D-YMD[4,2,2]") Thats only for date part. For time part give 2 as third argument of the Field() function and use the appro...

I know this is completely off topic but why are you doing all that cutting and pasting to get the job status. Use the -jobstatus option along with -run. The return code will be the jobstatus.

In server it does not matter. In px it does. If you have any background in programming, especially c, you will know that characters are not the same as integers. They need typecasting to be changed from one form to another. Similarly with PX, as it is strongly typed like C, you need the conversions....

vsi wrote:a) Should I check with invocationid

Code: Select all

JOB_STATUS=dsjob -jobinfo $PROJECT $JOBNAME.INVOCATION_ID(1...4) | head -1 | cut -d"(" -f2 | cut -d")" -f1` 

The way mentioned above.

AsInteger() and StringToDate().

Thanks Ken .

Yes. By suffixing jobname with .invocation id. i.e;

Did you completely overlook ArndW and my replies.

its not a function. just put square brackets" [x,y]" where x is the start point and y is the length.

Which btw, is also the same as server.