DSXchange

Hi all, I have experimenting with XML processing in DataStage so that I can help another team in our company determine if this will be the right tool for what they want to do. I have their XSD's and XML files. The XML file will import just fine, but the XSD files will not. I get the following error ...

Hi Ray and Kim, You guys are awesome! :D I appreciate all your assistance with my little 'labor of love' project. If I get it working, my intention is to make it available to the DSXchange community and to continue to make it grow over time. So, your wisdom (as one of Ray's taglines so aptly states)...

Hi all, I'm getting into the guts of the export files and trying to resolve duplication issues. One thing that might bite me is unique labels with regards to identifiers in the export file. I question whether the following fields in each of the DSRECORD or DSJOB sections of the file are unique withi...

Just to allay confusion before it starts: I meant to say that the delimiter is the pipe symbol ( | ) and the quote character would be three zeroes ( 000 ). Just in case you need to know where these settings are, they are found in the Sequential file stage --> Inputs --> Format. The check box for 'Fi...

Hi all, We had a problem similar to this. The main issue was that our data could legitimately hold quotes as part of the field. What we did was to take Ken Bland's advice and make our delimiter the pipe symbol ( | ) and then change the text delimiter on the file to be three zeroes ( 000 ). He also s...

Thanks, Ray. I will dig through the docs and see what I can find.

Bestest!

Hey Peter! (pclarebu): First of all, welcome aboard! :D On behalf of the DSXchange community, I'd like to welcome you to what I consider the best forum for this product. Now, to your post. I'm still fairly new to the product. Could you fill in a couple of holes for me please: 1. What version of Data...

Thanks for your input on this, Kim. :o That's a lot of code. I will dig through it and try to get my brain wrapped around it. I'm not DS Basic fluent yet, so it may take me a bit. I have already been working on getting the datatype mappings based on connection type by setting up an extract job to th...

Hi all! Would it be possible for anyone to send me a sample export file from systems/versions other than V.7.5.1a Server Edition? I would like to compare the generated export files to what I currently have to see what differences I have to allow for with other versions. Maybe a sample from Hawk woul...

Hi all, Just a quick thought (or two) on this: 1. Are there any foreign keys pointing to the table? If so, SQL Server doesn't allow truncate against a table that is referenced by FK's. 2. Instead of a semi-colon, have you used the tried and true GO keyword? I realize it's ancient and hokey, but it s...

Hi Kim, I'm still in the process of building my prototype jobs with a real table. I've only done it with a hand defined table to map all the datatypes within DataStage. I'll redo it with a small single table. Please bear in mind, I'm not looking for free work from you guys, nor am I in a position of...

Hi Kim,

Do you want me to email it directly to you or just post it here? I'll just pick one of our tables for metadata (a larger one to get a variety of datatypes) and either post it or email it to you as you desire.

As always, I appreciate your expert opinions,

Bestest!

That would explain it :? The basic functionality I'm looking for is the ability to give the program a DSN and have it go get the user defined table definitions and build two jobs for each table: 1. Source table to sequential file 2. Sequential file to Target table To keep it simple at first, I'm pla...

Hi all, Using some of your input I was able to find the solutions to most of my issues. Instead of imbedding sql into a parameter, I simply redefined the fields to what they should have been in the first place. The TRIGGER_STATUS field was defined as a char(1) instead of a smallint. Once I fixed tha...

Hi Ray, Thanks for getting back to me. When I go to New to start a new job, the only options I have are 1. Job Sequence 2. Server Job 3. Server Shared Container 4. New Job from Template 5. New Template from Job Am I just looking in the wrong place? Is this a new feature in something above Server 7.5...