DSXchange

Sure... you convert it. Look at what the Server job does and rebuild it as a Parallel job.

I don't believe that anything is corrupted here. I get the impression that they just mean an "ascii" versus "binary" ftp transfer which is all about converting line terminators or not, got nothing to do with characterset conversions. Now, if they used a utility to convert the fil...

I'm guessing that between the ORA-24374 and your mention of "userdefined select" that the latter is the issue and you seem to have a mismatch between what's in the sql and the columns you have defined in the stage. If you are saying that you are not allowing the stage to generate the sql, ...

As I said, I don't recall that being a restriction and unfortunately I have no way to run my own tests anymore. And the documentation is a little sparse on the subject, so I'm afraid others will have to actually help you with this. That or ask your official support provider. Sorry.

How will the number of times the job needs to run be determined? Sounds like 'ParamA' needs to be in the Sequence but wondering what 'fills it out'.

You need to tell the connector if you have the MQ Client or MQ Server installed on the DataStage server. And sorry, no connectors in Server... yet. Seem to recall plans to add them someday, though.

i did not found online payment safe It's an online world and only going to get 'onliner' as we go forward, so suggest you put your fear behind you and pay attention to where you go when paying and how that payment is done and make sure you have some common protections in place. For example, DSXchan...

They're part of the Packed classification of the Decimal data type, which includes zoned and overpunch and which allows you to specify whether the 'sign' is leading or trailing.

Plot out what those in-lined Converts do, first the inner one and then the outer. Quite clever, actually, made me smile the first time I saw it here.

Well, there's always Annotations on the canvas to address the whole "VISIBLE" aspect. Good, general, "best practice" stuffs.

Or just google, all kinds of references out there.

I believe that Kim may be thinking of the Windows Service Pack 2 fix??

Hmmm... something you could accomplish with an explicit Sort stage set to "Don't sort, already sorted" perhaps?

Yes - we know you "Need Help", that's why people start posts here. Let me see if I can help... [scratches head] hmmm...

Still would like to see my question answered.