DSXchange

Hello Jason, have you tried using the "upsert" method in your Oracle as a test to see if that is also running slower than expected? I'm not at a PC where I have the documentation available, but I would look at the environment settings that might let you defer the bulk loading to a manual start (as s...

80011 is an invalid user/password. I tried it on my system and it connected and listed the projects without a problem. We also have a system with multiple installations and they listed correctly. You need to specify the full command dsjob -server myserver:31538 -user me -password secret -lprojects

I though about doing the CONVERT, especially since it is more efficient than a user-written routine; but thought that it might contain more than just the standard non-alphanumeric characters. If the poster knows what characters might be in the data then a CONVERT is better, if it might be any string...

The 'MCA' conversion will return just the alphabetic part, the 'MCN' will do just the numeric but there is no conversion for alphanumeric only. I can do a MATCHES on that pattern, but couldn't get a way to have that answer returned. You could use the following routine I just clobbered together: Retu...

Do you mean to whether or not you can start your jobs via JavaScript? If that is the question then the answer is yes, you can start jobs. The Unix/Windows command to start datastage jobs is "dsjob" with some options. I can remember back that I did start programs using web-based js, so it shouldn't b...

You can also enter the command directly, it is DS.CHECKER

At version 7 (which is the version you posted for this thread) the DS.TOOLS menu options look like: 1. Report on project licenses 2. Rebuild Repository indices 3. Set up server-side tracing >> 4. Check integrity of job files 5. Administer processes/locks >> 6. Adjust job tunable properties

Odd, a search on this site reveals that the links to your newly created yahoo group are still in your posts. Perhaps you might post your e-mail address as well so that people can contact you.

The error message is from the local client program. Do you also have problems with the Designer/Director/Manager on that PC? It does sound like it might be time to give your support provider a call and let them see if this is a known issue already.

DS.TOOLS option number 4 is "Check integrity of job files"

Greg, it seems you haven't been to Europe - the radio and TV services charge you a hefty annual fee if you even own a receving device, regardless of whether or not you use it. I have a company, unrelated to this business, which has a website and we also have a T1 line (which we partially rent back o...

The Repository files are not listed or their columns described anywhere within the DataStage documentation. I recall seeing a post where Ray described some of the files... let me do a search ... aha, here it is I hope you understand why I am being so reticent about this - it takes a while to underst...

Just try both options in the DS.TOOLS menu again to be 100% certain that this is not the cause. And then try exporting just that one job and looking to see if the .dsx file is complete.

You can access the files, but they are not included in the normal automated drop-down list. You need to type in the name of the repository file(s) you want manually.

Will it work if you try the administrator from another client PC?