DSXchange

I just tried with the dsadm user account and am hitting the same issue. I was starting to think that this is similar to the read-only objects warning a person gets when exporting a project, but its not the routines were trying to overwrite. still the same errors (or similar).. Record J\22\V0S66P1 in...

hi all hope you can help. when taking jobs up from a development project to a production project using version control, i get the following error: Record J\11\V0S45P2 in file DS_JOBOBJECTS is read-only and cannot be written the result is that the job is taken live, but not compiled. Other jobs that ...

hi xli

Im no oracle expert, but tell us what add_months() does andn we can answer the question. Also, tell us what where you want to use this function so that we can suggest the best answer.

to do exactly what anupam suggests, DS.TOOLS will show a menu when you "execute" the command. i find that i always need to resize the screen once the menu is displayed. it makes for easy reading - from the menu, select 5 (Administer processes/locks) - then select 4 (list all locks) - make ...

hallo

where is the documentation on how to use the XML packs

I havent played with xml yet, but the documentation part you might need is in the install directory for DS client. the pdf is called: XMLPACK_20_Designer. If not there, check your CD for the pdf.

hallo.. when did you set the "auto purge" in administrator? The key here is to set the auto purge before you import your project. That means projects will get the default settings from the administrator. If you set auto purge after importing your project, only new jobs will purge after fiv...

I havent come across those errors, but this may help.. In DS 7.0.1 you need to bind DB2 packages to the DSN you want to connect to. For info on this, look in the install and upgrade guide (I am not sure this was the case for vers 6) Before connecting to a DB2 DSN you need to bind DB2 packages to the...

Perhaps a rule like automatic deletion from Saved after seven days? There's nothing to prevent a Save to a "proper" category, if that's the intent. This is/was the intent, but Im interested as to how we are going to auto delete after 7 days? Are we talking a bit of BASIC code that goes in...

Thanks a lot guys!

This is the kind of response I was hoping for.

Hallo Which IF statement is recommended, bearing in mind that the correct results, performance and ability to understand is what we are after.. if NOT(LINK_LOOKUP.NOTFOUND) and ( trimb(LINK_ROLLUP.ORGTG_IBT_N) = 2610 or trimb(LINK_ROLLUP.ORGTG_IBT_N) = 2710 or trimb(LINK_ROLLUP.ORGTG_IBT_N) = 5810 o...

I was afraid this was the case. Perhaps a good spanking is in order :D I think we'll keep to the standards we have and accept that using the repository is a learning process for the developers. yes... the table definition IM_SAVING_THIS_AGAIN_ZZZZ is stored somewhere and doesnt mean anything to anyo...

Hallo all This is more out of interest that I am asking. Is it only me, or is managing table definitions within DS a nightmare? I have developers creating table defs left right and centre (including me), and, even though we have predefined categories, we still have the odd definition being created i...

didnt want all data in one column and then what? well, use the substring to get the data out into the various columns through a transform stage. you'd need to know what you were looking for and where in the column the data is situated. you could alternatively have the shell script execute a datasta...

Do you have the FOLDER stage available for you? perhaps this could help. Havent used it myself, but one of our developers have. Otherwise, do the BASIC code you mention, the only problem I foresee is to determine that when a file is placed there, it is not growing anymore - i.e. all the data has bee...

Thanks dude It seems almost unfair to document something that can be done that shouldn't be done. Over here we have 2nd level login and passwords that also result in a headache or two. so.. dsadm types uv -admin -start and the prompt comes up for the 2nd level login/password. dsadm types it in and t...