DSXchange

Hi ArndW, Thanks for your time and response. Appreciate it much. To keep it simple, i wanted to create a simple job that uses an existing file on the server for its upload operation. Here is what i have in mind. SeqFileStage (Configure Zip file name) ==> FTP Stage (FTP folder et al). Is this the rig...

They are typically one very long line and thus not at all suitable for the FTP Stage. Stick with a scripted solution. ... Hi Craig, Ray, As I too am interested in an FTP job, to upload a compressed file from the DS Server to an FTP site, I was wondering how one should plan the error handling from t...

Hi,
It appears that this ECase was specific to
"ODBC Stage doesn't get Database schema from Netezza properly when RCP is used"
Is that what it was meant for?
I wonder if other users have the same issue of not being able to process a BigInt into a SQL Server DB using ODBC.

Thanks

Based on your description so far, it appears that your data is "truncated"/"lost" when it is stored in the target "Oracle" database, correct? The front-end apps are storing the data into the Sybase database, correct? Do you have any viewing application to check this at ...

Hi, I (re)searched several threads on FTP and found a lot of horror stories. Often times, it turns out that the best approach would be to use command line FTP and then get on with the actual job. My requirements are as follows. 1. Server Job1 creates an XML file from a datbase table 2. An "Afte...

Ultramundane wrote: Sure, (AIX and 752)

Hi,
Thanks for the quick response. Appreciate it much.
Is this specific to AIX or would it be for other platforms as well? I believe our Server is 7.5.2 on a Linux box. I will forward this to the Admin group and have them check this patch (ECASE 118069).

Thanks again,

Ultramundane wrote: There are patches out there that fix this issue. If you like I can try and track the patches down.

Hi,
I have a similar issue that i would like to have a patch/fix. Is it possible to provide any links/information that you might have?

Many thanks in advance for your help,

Hi Craig, Thanks again. As far as my DB schema is concerned, the EmpId is the primary key. I was confusing (I am still a novice to Datastage...) that with the XML Output stage "Key". In the final version........ For the XML Output stage, i marked the "Name" as the key. To be on t...

Hi Craig/Group, After posting the previous response, I took your suggestion (about Key column identifcation) as a cue, started reading (re-reading) the XML Pack Guide document, especially Pages 4-16, 4-17 and later to see if there might be some missing clues. Although i did not get a complete grasp ...

I'm pretty sure all you have to do to stop the 'grouping' is not mark one of the fields as the Repetition Element - don't mark a Key field in other words. Hi Craig, Thanks for taking the time to review and your feedback. Appreciate it much. I was away from work due to the "long" weekend :...

Hi, On second thought, I might not have understood the workings of the "Output Mode" in the "Transformation settings" page in the XML Output stage. If i select "Aggregate All Rows", i get the grouping of similar records, even though the key column has different values. ...

Pardon my amateur queries.... If I understand this correctly, if the xml chunks/fragments are persisted to file(s) before they are combined into the final document that should help with performance, correct? I wonder if that would be additional file I/O time that adds up to the total processing time...

Hi Craig,
Thanks a lot for the quick response. That was very helpful. I tried the "T" without the timezone information and it worked great.

Thanks,

Hi Group, In my XML output stage i need to emit date-time values for certain fields from a database column. When i let XML Output stage to produce the datetime values, it generates datetime values like "2007-05-22 14:32:59.140". When i run this against my schema, which has these elements d...

I already grabbed it Craig. It serves well, especially, when I consult it when i run into these issues. The other question I had on this topic is about the buffer length that Datastage can handle when one tries to bring together huge chunks and assemble them into one final master document. Any bench...