DSXchange

thanks for the update/info
In director : job : stop is active but reset is gray = not selectable
we tried stop = server was informed, but did not change the status.
Any other way to reset the status (maybe on engine machine ?)
Thanks and Best Regards, Guy Przytula

we missed an instruction in a routine and the job keeps running we tried to stop the job : status = running we did shutdown of engine and restarted the engine = status running we tried as in other topic COPY FROM RT_LOGnnn TO VOCLIB '//PURGE.SETTINGS' OVERWRITING CLEAR.FILE RT_LOGnnn COPY FROM VOCLI...

I used the technique with InString = OCONV(FByte,'MB0C') F1 = ICONV(InString[1,4],'MB') F2 = ICONV(InString[5,4],'MB') or with Ans = OCONV(FByte,'MP') in both cases, this is correctly done, but not correctly if input keeps the digit 9 or 0 eg. half 12345678 --> converted is correct as real 12345678 ...

it is not decimal just unsigned numbers. these are not amounts, and I don't know why they used this type of data to save this flags like : 14325678 where 1 means : next field is xxx 4 means : xxx and so on it is a group of switches can these translations be applied in a routine ? because we want to ...

Any idea how to handle in a routine compacted ascii data read from a file
digits are represented in half bytes
I want to convert these digits to real digits
Thanks for all help/info
Best Regards, Guy Przytula

a simple question would be : is it possible for a sequential file stage to specify for nls = ebcdic. when doing this : the message is displayed : nls map 'ebcdic' is not currently loaded, are you ... is this only possible when using cff ? when doing this with nls=ebcdic and defining layout - pressin...

We had a job that called different jobs. This job has aborted and now we have some subjobs for which we can not clear the log any more. When selecting : view log, the selection : clear log is not selectable. Is there any other possibility to clear this log. Even the output of latest run can not be c...

we have ds on solaris and had a problem with priviliges on solaris. the job was aborted, but a sub-job (called from previous job) stays in status Running/Restartable. We tried to stop this job, and even stopped and started the engine again. The job can not be started anymore, as it is running (accor...

Thanks for this update. Yes, I changed the metadata to char for this bigint column and this corrected the problem.
I will continue with ascential to see if this is correct.
Best Regards, Guy Przytula

Sorry, we are talking about DB2 for the moment.
The size of the field is large enough : 11 digits and bigint can keep 19 digits..
putting in a char field is no problem : length11 and correct
Best Regards, Guy Przytula

Thanks for the info, but this is not the problem.
It seems that data is converted to numeric like if you use date from character you also get a numerical value instead..
Hoping for other ideas
Best Regards, Guy Przytula

running the ds server and having an seq.inputfile data is extracted as char(11) for a specific field the transformer calls a routine that handles this value and the result is numeric field (all digits) I display the field before leaving the routine, and the value is correctly displayed and should be...

Thanks for all update I never tested this before - first ds job with remote ftp tried manual ftp : same uid/pw = no problem defined a simple file with 1 record and 10 char same operation on this test file = same problem ICPC_FTP..Transformer_2: Internal error: function 'buffer_to_row' failed Best Re...

No problem is NOT solved.
I mean : when doing the ftp manually = no problem
when having ds doing the ftp : I get the error
Best Regards, Guy Przytula

This just to indicate that local import is possible but ftp import is still failing
Best Regards, Guy Przytula