DSXchange

[quote="ray.wurlod"]Yes. Supported databases for the common Repository are:
[list]DB2 version 9

Oracle version 10g

SQL Server 2003[/list] ...[/quote]

But is it any problem to create Datastage Server and Oracle repository for datastage in seperate machine.

Please suggest me is it possible to create a Metadata repository in Oracle 10G Server in a seperate machine and IBM in formation server (Other parts than Metadate,e.g:Domain,Engine] in a seperate machine. I am using: OS:Windows 2003 Server R2 Datastage 8 [IBM information server] Oracle 10g Release2 ...

Is it possible to use an Environment Variable into any User Define Datastage routine.If so then please help me by a piece of code as an example.

I have a job:Pandora_Flexcab_BTP While i am using ExecDOS in after job of that job adding:move /Y I:\TELSTRA_DATASOURCE_ETL\FLEXCAB\SRC\* I:\TELSTRA_DATASOURCE_ETL\FLEXCAB\PRCSD I got an error as bellow and the job aborted: Pandora_Flexcab_BTP..AfterJob (ExecDOS): Error when executing command: move ...

If i invoking a SQL file through batch process from after/before job sub routine of DS job how can i trap the error of SQL file if it fails to run with out the help of director.

While running datastage jobs in Sequence then Jobs automatically aborted after 50 warnings.though individually it works fine.Can any one tell me from where it needs to change the limit of warnings in case of a automatically scheduled sequence job. I am using IBM information Server,in Windows 2003 R2...

i want to write some log message using the following routine.but it is not creating any file "I:\TELSTRA_DATASOURCE_ETL\FLEXCAB\TMP\LogFile.txt" Can any one help me to finding the problem: ErrorCode = 0 ;* set this to non-zero to stop the stage/job $INCLUDE DSINCLUDE JOBCONTROL.H cmd1=&quo...

[quote="chulett"]Could be because you are using relative rather than absolute paths for your filenames. If you still have problems, post your syntax. ...[/quote] cmd1="move /Y I:\TELSTRA_DATASOURCE_ETL\FLEXCAB\SRC\*.csv I:\TELSTRA_DATASOURCE_ETL\FLEXCAB\PRCSD" Call DSExecute(&quo...

While Opening IBM Information Server[datastage 8.0] client by the previously functioning user name/password i suddenly got an error "Failed to connect DataStage Server ... project: ..... ( The directory you are connecting to either is not a UV or does not exist(39125)" for a particular pro...

I want to use a batch file for moving some files to some folder to another folder.I am trying with adding batch by DosExec in Before job subroutine then it shows "Unlink" error though the command work fine from command prompt.It also gives same error while running it from routinr. Kindly s...

Can any one help me how to call one user written routine from another user written routine?Ie I have a routine called CALCULATION in datastage.And i have ADDITION,SUBTRACTION routines also seperately written in Datastage routine. Now i want to call ADDITION,SUBTRACTION routine depending upon some ca...

[quote="chulett"]That would be a PX answer not applicable to a Server job, please keep an eye on the forum you are in and to the Job Type. No can do. Oracle will only report [b]one error at a time[/b] even if you have a multiple problems. That's just the way it works. Unless I've misunders...

[size=12][/size] I have a record having comma seperated coloumns.There are total 50 coloumns.I want to check the error of the filed label incase of business logic and Oracle-table insertion error.Incase of business logic it is ok.But incase of Oracle-error while we are implementing with DSLinkLastEr...

I am using datasatge 8 in IBM information Server 8.0.Here i want to bypass the login screen of Datasatge with out entering login/passord.Can anyone give me any solution for it.I am basically try to pass it through a Java Screen.

I have some files in a folder .After checking some business logic i try to store the sucess and error files in seperate sucess and error folder.If a file contains all correct record in a file then store to sucess folder otherwise in error folder.And store the records in seperate sucess and error db ...