DSXchange

I'm sure QualityStage could carry out Ray's solution, change the field to title case and save it to a new field, compare the old field to the new field and reject those that are different. Could do it in QualityStage using a Select Stage. First define a field that is the first character of the orig...

But for some standardization jobs I need to specify the alternate locale in my run profile otherwise those jobs are getting failed. Eh? According to the User Guide, the Alternative Locale in the Run Profile is used when you need to run jobs in other languages. Is this what you need? (If so, I have ...

Hi All, I have one Quality Stage Matching Job . The job is running fine on one Unix server when I deploy the same job even with the same input files on different unix server then it is giving me the below error: I'm going to guess that it has something to do with the new location. Is QS looking in ...

A better question might be: why do we need to specify the Datastage version we are using? Some of us, for example, only use QualityStage, and so the question becomes completely irrelevant. I agree that knowing which software/platform you are using is important, but there is more that just Datastage....

"Datafile should be in the 'Default' code page....If click OK...it says .. "Results file should be in the 'Default' code page I recall that the manual isn't perfect and has some errors in it. The Datafile definition dialog box, for example, isn't the one in the manual. If you tried to mak...

Er, could be a large number of things, depending on what you have or haven't done. Is QS installed properly? Are the designer options set correctly? Is the Run Profile set correctly? (I doubt it is any of those, but just checking...) Did you Deploy the job first? Did you put a copy of the file in th...

Is there any document for exit status or if any one knows about the Quality Stage job's exit status then it would be helpful for me. In our system, we monitor for the file <jobname>.end, which appears in the SCRIPTS subdirectory. (QS should delete the file before running the job, but there's no har...

there are may b more than one record in which all the columns consist of the same information excepting one column which is RXID. so the file B is also not unique. i eed to match the two files and append the concerned columns to the file existing Do you need the RXID column of file b? Or a particul...

Certainly shows off how important DataStage has become.

Might i suggest splitting up the FAQ forum into FAQ and DataStage FAQ? (The latter in the DataStage area of course.) Already a lot of the FAQ posts are about DataStage items, and not all of us are DataStage users...

Cheers,
Jamas

We've been passing data to QualityStage from Sybase via an ODBC connection (although getting it working for our server set up took us a while). From the manuals, ODBC connections are fairly standard, and remove the need for a lot of file creation and even file definition. (Writing back from QualityS...

Couldn't transfer D:\Metastage_Projects\RAVIN\INV\GS000000.DIC to D:\Ascential\Projects\RAVIN\DIC\GS000000.DIC; Error(12003) Hi, From memory, I think that means an FTP transfer failure. Have you got the correct ftp rights set up? (Can test by trying to directly log onto that server via ftp, and mak...

Hi, ERROR: D:/Qualitystage_Projects/RAVIN/Logs/MATCH.Step001.log:DTF(2952):07/07/2004 05:26:19 PM (MSG_vio.c:12; vio.c:1516) ERROR: Incomplete record read from file Encountered this one before. You've got a number of possibilities here. Is the data file you're reading in the right directory? Does i...

Hi, But when I tried to view the reports by right clicking the job and clicking the "Server reports and Datafiles" option, it shows the list of reports but when i tried to view it, it is showing error like "GetNumLines: Cannot establish connection to server- inappropriate response fo...

Hello, When logging on to the Home page, we can see that there are X number of posts since last visit, and can then bring up the list of them. What feature would be nice (and is present in the actual Forums) is "Mark all posts as read". (I only read a few of the forums, so the ability to c...

Hello, Okay, firstly, not sure if it's called a bucket or not, that's just what I think it is. I'm talking about the icon to the left of the message/topic heading. Anyway, suggestion: When in a particular forum group, one can either click on the subject title, or click on the bucket, and end up in t...