DSXchange

chulett I did specify the boundries of the problem: Take a date time string and get it into a date-time data type in datastage. What I do with the data from there is my business and out of scope of the problem. Now with the combined responses from ray.wurlord and bheaton_ihc the problem can be resol...

This does seem strange. What time of day are you running your job, could either your source or destination tables be getting dropped due to a database backup or something? Also the designer will show green lines to a table when inserting when actually the director will log any warnings such as missi...

Thanks bheaton_ihc! That's a good example and I should be able to modify that for what I need to do.

Can someone help me with format mask, I'm reading in a text file with data like 11/16/13 9:30 PM MST So far I've only used ICONV for just the date portion but I have never done a date/time. I would expect a mask something like ICONV(DSLink1.Arg, "D/MDY HH:MM:SS AM MST") I did find this web...

Datastage 8.1 unfortunately

We're working on upgrading to 9.1 but that's still a couple of months away.

Has anyone else notice that if you have a job(s) that use a parameter set, that if a change is made in the parameter set, it is not reflected in the job? The situation I'm running into is I delete a variable from my parameter set but my job still thinks the variable is there and asks for it when I r...

Um I have my doubts that is correct. First since I've defined that the delimiter is a caret, datastage shouldn't be looking for a comma. Secondly and this disputes the buffer overflow theory because my work around was to leave the comma delimiter defined and send the data to a sequential file. Doing...

If the file that I am trying to ftp over is a comma delimited file, the stage works, but if the file is a ^ delimiter then I get a Internal error: function 'buffer_to_row' failed As a test I manually copied the file and tried using a sequential file stage with ^ defined as the delimiter and the stag...

I don't have access to DB2 but here's how you'd do it in Oracle, maybe you can translate the logic to DB2 SELECT SYSDATE AS Today, TRUNC(ADD_MONTHS(SYSDATE, -1), 'Month') -1 AS Minus_2_Months, TRUNC(ADD_MONTHS(SYSDATE, 2), 'Month')-1 AS Plus_1_Month FROM dual So for the start date, it would be take ...

So I've notice that DataStage will change which protocol it's using in the FTP Stage depending on which port number is used in the "Remote FTP Port" field. Specifically if I leave the default port 21 the FTP stage works just fine and I can process my file. BUT if I change the port to 22 in...

This issue has also bugged me to. And I understand all the arguments that pretty XML isn't a requirement but unfortunately I have to work with submitting XML to other systems that suck and require pretty XML. So just wanted to post my work around to getting pretty XML, unfortunately it involves huma...

UltraEdit won't compile, test, debug will it? I've written my own syntax highlighting in Notepad++. That's why I started looking for a plugin to Eclipse so I could leverage the intellisense, compiling, debug step through, capabilities of a full IDE.

Does anyone know of an IDE for Datastage Basic?

I was hoping that Eclipse would have plugin but couldn't find one. It'd just be really nice to have something a little more robust when writing my custom server routines than the editor they provide.

I think going from the XML Output to a Folder stage is probably the right track. I read too the documentation mentioning the use of %% and %@. When I connected a folder stage I started getting mapping errors on my job. I'm probably not using the Folder Stage correctly. Because the input on the XML i...

Does anyone know if it's possible when outputting xml to a file to control what the file name is going to be when you split it? All my tests show that it just starts appending 1...99 to whatever root name I give it.