DSXchange

If the two boxes are the same meaning that the versions of DS are the same and the versions of SQL Server are the same then it would seem to me that this problem might be related to the environment on the non-working server. I will have to ponder this a while longer so hang in there and hopefully so...

Please visit This link or That Link

I was neglect in that I did not do a search before posting my solution. I still believe it is a valid post, but I have found the following post Check This that may help you.

dsmsdbl.dll is NOT a SQL Server client dll shipped by MicroSoft, rather this is shipped as part of DataStage and should be found in the engine\bin directory. The properties state - DataStage DB Library bulk loader for Microsoft SQL Server Copyright (C) 2004, 1997 - 2003 Ascential Software Corporatio...

Here is a link that might be what you want -

Administering Universe

edit: Here is a link to view all Universe pdf files available on the IBM website -

All Manuals

If what you want are the column names from a particular table and stream this as data to a target then you could use a query like the following to select a list of column names - select COLUMN_NAME from information_schema.columns where table_name = 'TABLE_NAME' Make sure you are connecting to the co...

The objects that Kim is referring to are the repository files that the API references. Boh Kim and Arnd have valid points, but I would err on the side of caution and urge you to use the method Arnd has posted since this will not likely cause any issues from release to release. The field positions th...

Phil,

Any jobs that reference the Complex Flat File? If so are the rows pretty wide? What is the number of jobs that you are importing?

There was an issue with this in earlier versions when importing - there was a fix although I believe 7.0 has the fix.

Just a thought.

Your solution will work somewhat ok (albeit fairly inefficient) for strings like the two you posted. What will happen if you get two strings like - Dr. John Doe John Doe, Doctor or Mr. John Doe Mr. Jon Doe In your method these will never match although in reality they probably should. There is value...

The DataStage repository files are not visible via the manager for import, therefore you would not be able to import the dictionary of the file.

This error is basically telling you that there is not sufficient paging-space pages available to fork an additional process. Normally the parent process will retry at lest 10 times (AIX) before failing. This means that after 100ms the process will fail. You can increase the number of retries to some...

Another possible solution might be to push this logic back to the source system by requesting that these transformations be applied at the source via a COBOL program. This could work if A) the resources exist to do the work B) the logic is not dependant on anything external to source system Just a t...

If Menge is not null and Vgabe is 8 then what is the value of Shkzg? If this is anything but an "S", "" or "H" then Ans will be 0

The ! and OR is ok (along with AND and &) - both work. I copied your program as it is and tested it myself and it works for all combinations where Menge is not null. I suspect that you are either encountering the situation where Menge is null when Vgabe is an 8 or Vgabe is not ever an 8 when Men...

If you would have created five (5) identical jobs to do this processing with the only changes being the input and output file then the answer to your question is Yes. One job sufficiently paramterized with the "Allow Multiple Instance" set to true will do exactly what you want and can run ...