DSXchange

Through DataStage Director.

Tony

I understand. There are other ramifications, such as if they use a terminal emulator to log into the UNIX box and look at the data while developing the jobs. And as I said, I suspect that they do have encryption on the links, but they insisted that we encrypt our Oracle connections to ensure that th...

If someone does look at all the packets on that port then they will get.... DataStage stuff. Not much clear text there to pose a security hole. I understand that the DataStage client is written in VB or some .NET language. As such, I imagine that they're using conventional classes/objects to transp...

I understand about the difficulty of spying on the data. My customer insists that any data going between our cities be encrypted. We made arrangements with our respective DBA's to encrypt the Oracle connection. this was the only other way that I could think of that any data could be exposed. I suspe...

I have noticed that occasionally I have a job sequencer that doesn't run when it's scheduled. It runs ok before and after the event where it didn't run. If I look in the Job Log when this happens I see the entry for DS.SCHED where the scheduler fired off, but no entries at all for the job running. I...

I have a requirement for some folks in another city to use our DataStage server to develop and run some jobs using their own data. They are concerned that if they view data in DataStage while developing their jobs, that the data will be exposed on the network connection between our server here and t...

Ray and Tom,

Thanks for your help. The developer got it to do what he wanted by playing with Key Fields in the XML Writer.

Sorry about the delay in responding.

Tony

Can anyone help me get some data output in XML the way my customer wants it? What they want is: <Interfaces> <Interface>Data from Row 1</Interface> <Interface>Data from Row 2</Interface> <Interface>Data from Row 3</Interface> </Interfaces> In the XPath I have /Interfaces/Interface/Data1/text() /Inte...

Craig,

I had similar experiences as you did. I had to mention each key and put the begin, end syntax (e.g. -k9,9) to make it work.

Just my 2 cents worth,
Tony

I suspect you may be able to do this with 7.5 by building a Job Sequencer job that loops, filling the BU and InstanceID with distinct BU values from the data. Obviously, you would have to figure out a way to feed the list of distinct BU's to the loop.

Good Luck!
Tony

pkl,

Sometimes, if the metadata (especially key info) for a hash file has changed, you will get unexpected values out of the hash file. Usually, the value is in the data record, but not in the field where you're finding it.

Good luck,
Tony

I doubt if this is the issue, but... If you login to Administrator, click on the project and click on the Properties button, you should see an NLS tab if you have NLS enabled on the server. If NLS is enabled, the NLS tab should show the default character set for the project. It's possible that you h...

NLS issue, then?

I had this problem once, where nulls in the hash file (I think the in one of the key fields) were "converted" to an odd character. I ended up testing for the value that was in the field and converting it to null on the output. I think it was Char(254) or Char(253), but I can't remember. Go...

Dick, You can extract them from the data1.cab file in the DataStage Windows Server install. I downloaded a InstallShield CAB file extractor utility and used it to extractthese files from the Data1.cab file. You need to put these in the same directory as the dscmdexport.exe. FYI, you also require the...