DSXchange

OK but when I edit it witk notepad, the result is exactly the
same.

Do you mean that my problem can't be solved ?

Patrick

I just double click on it
(internet explorer is launched)

I have a very simple job SEQ FILE ----> TRANSFORMER -----> XML File In my sequential file, I have a certain number of columns Some of them could have the NULL value When I generate the XML file, Tags are not appearing in my XML file when the DATA is NULL I want to see the TAG in my XML result File a...

I have just phone to the french ascential hot line
and they told me that there in no number column
limit for universe table but the limit is fixed (by ascential)
at 8192 columns in a hash file ...

I Hope it may interest you to know that ...

OK

can you give me more explanation about your answer or
show me an example of code you use in your job control...

Thanks a lot

OK, I will try to explain When we run job (via a job control), it happens that this jobs begin its treatment and after, it stays in a running status but the number of treated records doesn't increase (maybe a lock on the database, problem with HSH or Sequential files ...). Even, It can be in a runni...

Thank you for your answer, that's what I thought I advise developpers to create very little hash file (one key, one field you want to use in a look up ) but they prefer build a very large hash file which will be used along the whole process (more than 100 times) . Do you have any ideas about my seco...

does anybody know if there is a maximum number of columns in a hash file. We are working with Hash files which have more than 150 columns, and the result is that we have poor performances, even some jobs are in the running status but links are in a starting status and the jobs do nothing So here is ...

denzilsyb wrote:Try using Iconv to get the time to an internal format, do the calculation and then Oconv the value to the format you need.

the help details iconv/oconv quite well.

dnzl

Yes I knew that these functions were useful, but I wanted to if there
were other functions

I will use them

Thanks

When I launch a job, i save the startdate and starttime in order to write them later in a file. I use the DSJobStartDate and DSJobStartTime functions (I can't find them in the documentation !!!, maybe can you give me any link). What I want to do is to make time calculation If the current time is 10:...