DSXchange

WoMaWil

there are several look into manual or help

WoMaWil

You could have done a SEARCH before asking and having found this:

viewtopic.php?t=113806&highlight=transf ... difference[/url]

WoMaWil

Try to fill one sheet after the other....

WoMaWil

But you can use the Reporting Tool, which will transfer all actual available metadata to a Database which you can analyze the way you like it.

WoMaWil

Then it seams that subqueries are not supported. So transfer your source-Data into one new HashFile and use this new file as Lookup.

WoMaWil

Hi Victoria, If you Code something like: BCP "select '**ROW**', email_msg, email_id from emails" QUERYOUT "c:\email.txt" -c -T -S sunny.erwin.com you can tell DataStage, that a line beginning with **ROW** is a real new line and all other new lines belong to the row before.

WoMaWil

Try

Code: Select all

SELECT code, surrogate_code FROM 
( 
SELECT branch_code AS code, max(branch_surrogate_code) AS surrogate_code FROM branch_pointer 
UNION ALL 
SELECT office_code AS code, max(office_surrogate_code) AS surrogate_code FROM office_pointer 
) AS T 
WHERE code = ?;

WoMaWil

General rules cannot be set, experience is the way to get more sure. We have 7.5 and 7.5.1 servers and 7.5 and 7.5.1 clients and we see lot of problems going cross those versions with clients.

Okay, I know, you can say: MOVE TO SAME VERSION, but sometimes I am not as mightyfull to demand it.

WoMaWil

Not only Bangolore is able to organize big parties.

All you Gurus (Ray, Arnd,Craig Hulett,kenneth,Kim Duke,roy,vincent....) should know if any or more than any is coming to central Europe, we have enough Wine, Beer and Whiskey in stock for a big welcome. So if you like parties anounce your come....

WoMaWil

does an other user has access to your project?

do you have access to an other project on this server?

WoMaWil

(1) choose projects
(2) choose command
(3) use DS.TOOLS to find the jobnumber of the logfile
(4) write on the commandline "SELECT * FROM RTLOG_<num>"

WoMaWil

Try first to restart your PC and then try again to export. If not you get it working you will get the next tip.

WoMaWil

if you have read-write-rights for this file you can see it. If you collegue hasn't given you that you can not....

WoMaWil

Metadata are stored in the DataStage repository in many tables there. Where and how is not published. Some of the gurus here have done some research. In Manager there is a Reporting-Tool with which you can shift a copy of the most valuables to a DataBase via ODBC on your PC. Possible DB are MS-Acces...

WoMaWil

don't delete it in UNIX (or Windows). Look at the rights. Maybe someone else has saved it without giving you the right to compile.

Search found 464 matches