DSXchange

For the Perl based cutter in this thread you can use Cygwin but you can also use ActiveState Perl: http://www.activestate.com/Products/ActivePerl/ The Perl cutter works fine but it has a few issues: 1. It only 'cuts' jobs and nothing else like shared containers, etc. 2. It drops some lines from DSX ...

ray.wurlod wrote:What's the ping time on your LAN? What does that say about relative speeds?

<1ms

Can anyone tell me their 'wan' login times?

DSguru2B wrote:WAN's will be slower than LAN's. Thats a limitation from your WAN service provider. Can you watch streaming videos without any pause in them?

Throughput is great (1500 Kbytes/sec) in both directions. The ping times are right (31ms).

When using the DataStage 7.5.1.a Designer over a T-3 (45mbit/sec) link seems several times slower than using Designer over a local LAN. For instance, the initial login takes about 35 seconds over the WAN link while it might take 4 seconds over the local link. Anyone have any tips on how to speed thi...

Is anyone using SQLite with DataStage here?

Is that possible?

thanks!

There are free libraries available that can be used in perl scripts, which look amazingly like korn shell scripts, that flatten XLS spreadsheets into CSV files for the worksheets contained therein. They will materialize data out of cells containing functions, as well as do other things. You're on y...

Just an FYI.. My recent backups of some of my DataStage projects have been around a gigabyte in size. Aside from 'chopping' the extracted DSX file and versioning the individual jobs in Subversion I have also been saving a zipped copy of the DSX file, just in case. Recently I tried 7zip because I was...

Dear All, Our warehouse project has about 3000 jobs and we need to export the job designs[not the executables] individually without their related shared containers included. I am using a tool to export the jobs individually which uses "dsexport" but it is including the shared containers a...

There is also a Perl script which someone posted to split a full export into one per job. I think it is called DsxParse.pl. BTW.. I think I just found an error with the ParseDSX.pl that might be a show-stopper for some people out there. The error (again.. I think) is if you have a line in your DSX ...

I think I saw a post where the answer was "no".. but I just want to ask again to be sure.. I am creating some scripts that check jobs (and other DSX files) out of a version control system and then imports them into a Datastage instance under a specific project. Is there anyway to have thos...

I have a folder with 1500 jobs and about 45 developers.. Is there any way to figure out (besides the obvious thing like asking my developers) who was the last person (or user ID) to modify or create a job?

thanks!

This is a newbie question..

Is it possible to 'package' (like in a RPM or DPKG format) the deployment directory that is created after a job is compiled and move that compiled job to a different DataStage server that is running the same OS and DataStage version?

If anyone else sees the merits of having shared containers 'cut out' too.. I'll gladly give it shot.

I tried the new version.. and it worked great.. thanks!

I was wondering why the script doesn't handle other object like shared containers, table definitions, stuff like that?

thanks!

AFAIK, this would require some very heavy customization / integration. hi all i need some detailed inforamtion regarding ILOG and DATASTAGE i mean how to use JRULES stage( ILOG) in DATASTAGE and how to configure, how to work ,how to trouble shoot etc... any help would be greatly appreciated thanks D...