DSXchange

I tried to use the transform 'NullToZero' in a controlling job and declared it like this (also tried some other ways):

Deffun NullToZero(A1) Calling "DSX.NULLTOZERO"

Is it possible at all to call transforms? Thanks in advance for any help!

What's going on here

You can do it manually in Director by chosing Project -> Print and checking the 'Print to file' option. DSGetLogSummary and DSGetLogEntry look like you could do something similar. I am furthermore quite sure that, I think it was Kim, posted code that did exactly that. If you are only interested in p...

Girishoak, in Designer, I think, at the first glance you get only table definitions that have been saved to your repository. There is, however, an 'Import' button in Designer which will display the same DSNs as in Manager. DSNs you want to see here got to have an entry in the uvodbc.config file in t...

Another workaround is doing the lookup against a uv table. Nevertheless you would not be able to take the field in question as part of the key, because uv tables use the same hashing algorithm. But afterwards you can do the lookup using any columns. For performance reasons, you might consider to cre...

Assuming, the file to be processed has today's date in its name, you could have a controlling job that evokes the job processing the file. Derive the filename something like that: filename="somefilename":oconv(date(), "D_DMY[2,A3,2]"):".csv" After that you can pass the ...

To rename a file you can use a similar synatax in an after- job subroutine, like (how was this in Windows?): ren file file_#DSJobStartDate#.txt. In Unix, I would probably use the OS to create the new filename, like:

mv file file_$(date '+%Y%m%d').txt

I found it:

viewtopic.php?t=85059

and sorry, It wasn'r Michael but ariear

Can't remember, try to use

DSJobStartDate
DSJobStartTime
DSJobStartTimestamp

in your file name specification. like

file#DSJobStartDate#.txt to get 'file_2003-10-23.txt' as your file name.

A couple of weeks ago, Michael Hester pointed out that you can use DS makros just like job parameters, surrounded by hashes, to achieve that.

Jauthier, Looks like you can do in the columns page of the ouput tab. Introduce new column names under 'Column Names' and type the derivation under 'Derivation', e.g. ColumnName=columneight Derivation=decode(x1.datent,x2.datent,null,x2.datent) Specifying 'ZZZ xc,ZZZ x1,ZZZ x2' as Table Names on the ...

As a workaround, I created three separate input links to the uv-stage to each execute one single sql.

Hello folks, I'm trying to issue multiple sql statements (as user defined sql) in a uv stage to drop and (re-)create a table and subsequently create secondary indices. I know that I can drop and create by enabling the correspondent controls. But whith user defined sql, statements separated by semico...

Hi folks, if I create a uv-table (using a uv-stage, not a hashfile-stage), I have to specify the columns forming the primary key. Will there be a (primary) index on that primary key columns (Querying this forum gives the impression that an index will not be created)? Ray mentioned, that secondary in...

Kim yes, I also experienced problems with the dsjob command regarding the invocations. dsjob wasn't able to return the correct list of the invocations of a job, usually you get only the job itself. Specifying an invocation as an argument to dsjob, the list will only contain that one invocation. Kind...