DSXchange

As you can see, the consensus in this thread and on the forum is that the import will not work without actually logging in. :cry:[/quote] I created a local user for the server box and logged using the user id / password from Datastage client. Now using the Manager i imported the DSX file to the serv...

Now, I am able to see the following info after i ran the job. Designer : The links are in red color . Input and output data are able to view using the "view data". Director : The following messages are displayed. 1) ANSHMANP..Output_Numbers: Using project default NLS map MS1252 2) ANSHMANP...

I am also getting the same error. The error reads as : ANSHMANP..Output_Number.DSLink5: DSD.SEQOpen Failed to open Number_Manipulation.txt in directory c:\output_data_ds STATUS = 2. I was able to read another file in the same directory for some other transformer job. I dont have any permission issue...

But , cant i give only 1 constraint for Clean data .
No constraint in Reject data and check the check box for Reject Row.

I tried by this method and i am getting all records (including the rejected records in clean data). Reject data is getting correctly.

Any Suggestions ...drop a reply.

Hi ganive, Thanks a lot for the useful information. That really helped in getting the things done. Resolution : 1. I have created 2 constraints for both the links (clean data and dirty data). 2. The constraint for clean data : DSLink4.No <= "105" 3. The constraint for clean data : DSLink4....

Hi All, I am getting the following error when trying to access a Job. Problem Desc : I have created a Job "Testjob" and been using since 3 days. I have been designing various transformations and able to work. When i tried to access today, I am not able to access the Job. Instead, I am gett...

Hi All, The query is for sending the reject records to a sequential file based on a criteria. I have a input sequential file : which has 10 records. I have a transformer defined which splits the data based on the criteria and directs to clean / reject data (2 sequential files). I have used a single ...

hi all,

Thanks a lot for the information. I am able to access the server jobs from the client boxes as mentioned.

Thanks once again.

Regards,

ArndW, I created the project dstage in the client using Administrator in my earlier installation of client software. It still got retained in the buffer. Steps : 1) I invoked the datastage-->Manager in client box. 2) I entered my windows credentials (userid/password)for the datastage-->Manager . [I ...

Hi , Thanks a lot for the useful and fruitful information tips reg the importing of DSX file. Here is the update few mins back i got. I am able to connect to the server box with my credentials. I have logged in the Box A (server) with my username / password. I created a dummy project (dstage) in the...

Friends, Let me tell in detail. Datastage 7.5 Server software installed in Box A. Datastage 7.5 Client software installed in Boxes B,C,D,E. client Licenses : 8 Nos I have a .DSX file (jobs /schedules / sequences etc...) I need to import the .DSX file to box A (server) How to go about this ? Client a...

Hi , I tried to see the menu once the Datastage server is installed in the Windows 2000 Server box. I am able to see only Datastage package installer. Apart from that nothing in the start menu. Keeping this in hand how can i import the jobs in the Datastage server. I have a DSX file (contains the jo...

Hi all, How can i import the DSX file.? The problem : I am new to Datastage. I have installed 7.5. The Server version is installed in box A and Client Version is installed in box B. I need to import the DSX file and be available for 4 more users to access the DSX (which has jobs/ processes / schedul...

Hi all , while importing one of DSX to a new project i am getting the following error. #1) Error calling subroutine:DSR_RECORD(Action=2):Check Datastage is setup correctly in in Project. (Internal error (82021)) #2) Error in command 'CATALOG RT_BP612 JOB.1381048179.DT.1354842861 JOB.1381048179.DT.13...