DSXchange

You are infected or you were infected with zlob? If anything in the Server install was infected and then removed (or horked) by the virus or the cleaning crew, then I'd say yes - you would need to reinstall your Server.

Ok... that seems... fine. Are you setting any other 'NLS' parameters there? Is so, post them - both the variable names and the values you are setting them to, please.

The job is completed while reducing "The parallel degree for the sql statement from 8 to 1". Why parallel degree 8 works sometimes and not others? That would depend on exactly what else is going on at the same time. And I doubt you needed to drop it to 1... why not try a smaller number, something t...

Oh my. In your DSEngine directory, which should be pointed to by the $DSHOME environment variable.

Also, what version of 7.x is your installation? I don't recall there still being an OCI7 stage in that version.

You can only use the 'omit' option if you have a Windows server - and you've stated yours is UNIX.

You certainly can use DataStage to do this. Typically, however, if you are simply going to move large amounts of data between two tables with no 'transformations', you'd be better off doing it with the tools supplied by the database vendor. Or just a big parallel query. Another 'however' however - i...

Define what 'archiving' means in this case.

To me, the error looks more like it's a parallel query coming from the source rather than the target side. In any case, talk to your DBA. They will berate you for whatever you are doing - something that needs to do alot of sorting, possibly - but then may increase the TEMP tablespace for you. Either...

You either need to look at the sdk routine you mentioned and write your own version that goes 'backwards' or use the CFF (Complex Flat File) stage to write out the file. I'm guessing there will also be an EBCDIC requirement you'll need to handle and the CFF stage will do that as well, from what I re...

Besides the fact that when calling something like that X times, you stand a good chance of it changing. Maybe that's ok and maybe it would be a Bad Thing, so you call it once and use a known consistent value.

You problem may also be the NLS setting of the tool/platform used to view the sequential file. I just went through this recently, the file was fine but my pc's NLS setting was 'wrong' and so it looked... bad.

the value for NLS_CHARACTERSET IS WE8IS08859P1, but this character set is not displayed in Datastage. I checked the nls_database parameters, the character set is same as specified in datastage. These seem to contradict each other. Please post your exact NLS_LANG setting from your dsenv file. I woul...

Ray meant we need to know alot more. You should take a shot at answering the questions Ray asked before anyone can help much.

Looks to me like your Oracle dates were being selected in YYYY-MM-DD format under 4.2 but after upgrading to 7.5 they are in YYYY-MMM-DD format. I'd be curious what stage you are using (OCI?) and what datatype you are using in your source stage - Date? Varchar? As Roy notes, best practice is to not ...

And we know it's all about the points, baby. I'm saving for my second pony.