DSXchange

Ray said 'FTP' not 'the FTP Stage'. You'll find the stage problematic for things like XML files as the stage is metadata driven and will want to transfer the files one 'record' at a time. While you may be able to get it to work if you haven't formatted the XML output, you're better off learning and ...

Doh! Could have sworn I rolled back and checked the OS on the first post, obviously not. Perhaps it was your 'ls -rt1' and the mention of the remote UNIX server that threw me... Still, that's still all there is to it - other than the need to invoke ftp with the -i option to turn off 'Interactive' mo...

Short but correct, regardless. You'll need to 'script' the ftp of the two files to your remote server. If you don't know anything about ftp, is there someone there where you work who does and would be willing to write the required batch file for you? Or try to Google up some examples. Manual FTP is ...

Vinod, I guess you missed the part where they stated "It is working after the installation of the patch".

It's the same as 'get' just with an 'm' on the front and a wildcard in the filename. That's it. Try 'man ftp' for more information.

True... just be aware that all of your version numbers will restart back at ^1.

To get an idea, pop open the ones that ship with the product. A double-click will reveal all, including their source code. You'll need to write a routine to return this mysterious value and pass it back out as its Ans(wer). Call the routine in a Sequence job and any downstream Job Activity stage can...

Welcome! Back in the old days when I worked with Informix, I recall it having the same behaviour as the Oracle databases I support now - it is perfectly happy to update or delete a nonexistent record. We'd need to investigate the sqlca area where 'the number of records effected' by the current sql w...

I calculated the file size by adding data.30 file and over.30 file. All the hashed files in this job are static pathed hashed files. These two statments are mutually exclusive. Static hashed files don't have ".30" files that live in a directory - those are dynamic pathed hashed files. And you'd nee...

What is the actual data type of the last column? I know you keep saying they are 'integer' but it doesn't matter what the actual values are, just the data type declared in the stage. It must be some kind of string for it to be quoting it... either that or you've uncovered a very odd bug.

Which is what Arnd posted yesterday.

Welcome. First thing to note - two completely separate questions belong in two posts, not combined into one. Having said that... 1a. No. 1b. Not that I am aware of. 1c. No clue, not convinced it's a 'problem' yet. Examples are always good. It would help if you posted the relevant information from th...

Welcome! First thing you should always do is Search the forums for your error message, odds are you are not the first to encounter it.

An Exact Match search on "Error setting up internal communications" returned several hits for me, please see if any of them help.

Surrogate Key stage.

Welcome. First off, I'm not really sure how to 'help urgently' but I am typing as fast as I can. Understand that this is an all volunteer site so there really isn't anything as urgent, you get whatever you get whenever you get it. If you've got a truly urgent problem, contact your official Support p...