While the DIGITS transform will remove the 'dot' there is an official way to do that using the FMT command all at the same time. Check into the 'descaling' option.
Jobs run the same way when started in the Designer, the Director and the command line, so that wouldn't have caused your problem. Not quite true. The difference? Jobs run from the Designer default to allowing unlimited warnings, which fools many people into thinking their job 'ran fine' because the...
It's obviously a message from a Sequence job with the 'Automatically handle activities that fail' enabled. MappsMDI205ProjectsExtractJob is a job it was running that aborted and the Sequence decided to handle. You need to dig into the log of the job that failed to find out why... what you posted isn...
Has anyone faced this issue that new line in input XML is considered as data? So this is the question, eh? Short answer is 'yes'. Somewhat longer answer I was given by my resident gurus was it depends on the parser. They also did not like the so-called 'format' of the formatted output. And I didn't...
Post your routine code. Plus I'd suggest you think about doing this 'post job' as in a Sequence job or possibly after job. It depends on exactly what you mean by 'display an error' if the processed row count is zero.
Yah, same here. However, since this is 'only a development server' I won't be able to get my virtual hands on one until tomorrow during 'working hours'.
Interesting... in spite of the fact that 'dsadm' is the administration user and has 'DBAUTH' privledges, I can't "FIX" UV_USERS. First thing it says when I try is: User does not have superuser privledges! Disabling the FIX option and continuing. What, I have to be root? That's not gonna happen...
Thanks. 1) Both DATA.30 and OVER.30 are 4096 bytes with dates from 2005. 2) No, I get the same 'read operation failure' as noted before. 3) First it lists the filename, then 'File has 4 groups' and then lastly a similar 'read operation failed' and 'Internal data error'. Doesn't seem like a repair wi...
You'd have to tell me if this means it is repairable or not... I'm assuming it is but will wait until our scheduled maintenance window tonight (or a reply back) to find out. >UVFIXFILE UV_USERS File modulus is greater than physical file. Invalid nextsplit ptr in header. Beginning TRACE of sql/catalo...
You had an extra 'A' - it's DBAUTH. And here's what happens when I run that: >SELECT * FROM UV_USERS WHERE DBAUTH = 'YES'; User Name.......... dsadm DBauth Privilege... YES Resource Privilege. YES Author............. dsadm Own-Table Schema.. Owned Tables...... CATALOG UV_TABLES CATALOG UV_COLUMNS CA...