DSXchange

The grep command has a -v option to perform a reverse search. This should achieve what you need.

Welcome to NLS! To get the import to work, you can change the CharacterSet parameter in the export file header to whatever you're using. Microsoft uses its own character map names, that differ from those used everywhere else, even where the map is identical. I guess it's so they can accommodate thos...

Welcome aboard! :D Are you really trying to communicate with SAP using DataStage Enterprise Edition on a Windows machine? You might also enlighten the community as to what you mean by BAI2 files. For example, given that they are a standard format, what exactly do you wish to achieve? And by what mea...

Did you start DataStage as root or as dsadm? If the problem persists, try the other one. Also make sure that dsrpcd starts.

User/system/file DSNs are only relevant in the Windows environment. In a UNIX environment you simply create DSNs. You do so by editing the .odbc.ini file in $DSHOME directory. You also edit uvodbc.config file in any project needing to use that DSN, or use a central uvodbc.config file in the $DSHOME ...

There is no IN operator, so you probably need explicit equality tests for REC_CD, or a range test and an exclusion for '927'. A neat way to do range checking in server jobs (incidentally you posted in the wrong forum) is Oconv with an "R" conversion. This allows multiple range checks in a single fun...

More is always better. For PX on Windows I'd advocate at least two real (physical) CPUs, at least 512MB of memory, and lots and lots of disk space. For development, that is with low volumes of data to process. Keep in mind that you also have to install the Visual Studio .NET C++ compiler, which eats...

The perils of inattentive copy/paste programming! SHould have been:

The expression (If Club = 'c' THEN '2' else '0') can only return "2" or "0".

Good catch Ken.

I believe that most of the static hashed file utilities (HASH.HELP, FILE.STAT, HASH.AID, GROUP.STAT, etc.) require the VOC pointer. You could always remove it afterwards.

Did you check Display Width (not Precision)? Display width affects the width used in fixed-width format text files. Precision is part of the SQL data type definition for Char and VarChar data types.

Have you used the name Sequential_File_10 for a database stage??

The error message suggests that you have an expression that uses a field name sqlcode, but that this does not exist in an input stream, or is incorrectly qualified (left over from an earlier version of the job design perhaps).

If you've shut down DataStage with these types of error and ipcs shows that there are shared memory segment keys of the form 0xadexxxxx, then you can - as root - remove these shared memory segments using the ipcrm command.

They generate error messages! If no-one else is using the project, you can use uvbackup. Log in as superuser. cd projectname find . -print | uvbackup -f - -V -s /tmp/summary.txt > /dev/null Look in /tmp/summary.txt to get a count of corrupted files. At the end you should see something like: Total fi...

The expression (If Club = 'c' THEN COUNTRY_CDE = '2' else '0') can only return "2" or "0".

As I said, it's just arithmetic. If today is Wednesday ( 3 ), then the Friday of this week is two (5 - 3 ) days on. Friday of the following week is that plus seven (5- 3 +7 added to current date). Friday of the previous week is (7- 3 +1) days before. Subtract from current date. Until and unless "the...