DSXchange

Hi All, We have a requirement where we need to connect to over 20 Source Databases with different Connection Information and so each will need atleast params for DSN, User and Password..My questions 1. Is there a Limit on the the Number of Parameters we can use in a Parameter set or any performace i...

I was able to successfully run..I was not giving the port number post the domain name. After adding the default :9080 to the domain name and it ran fine

Hi Nagarjuna,
Can you please provide us details on the resolution, as we are also facing the same problem

Hi All, We have V8.7 on Windows and Engine on 1 Tier and the Services/Metadata tier on another server Under Engine Credentials, we have used the option to share the user registry (but we have not been able to set to use Active Directory yet) We created a new user, say "usr" with relevant p...

No - Actually, My requirement is not to process any records even if "a recored" is rejected on some conditions.

Hi All,

I have a requirement to reject entire file even if a single row is not matching the defined business condition.Also, Job should complete as successful without any failure.

Please let me know if it is practically feasible.

Thanks,
synsog.

Hi All, V8.7 on Windows. When we want to move jobs between Env, say Dev to UAT, is exporting the Job designs with Executables and the Parameter Sets enough, or do we also need to export the Table Definitions? Can we use the Information Server Manager (will create .isx ??) for this by creating a pack...

Hi Team, I need to FTP a file from mainframe server to Datastage server using FTP Enterprise or FTP Plugin stage. Can some one help me to understand, which of the above mentioned 2 stages is right choice ? Also, it would be great if some one help me with Properties to be supplied or good documentati...

I have 100 files in a folder. All file names are started with name TU_*. I need to pass 1 file name at a time to a server routine which need to exectue in sequence job. Suppose today there might be 100 files, tomorrow,,, 200 files .. so on a day.. if N number of files present, then the loop should e...

Hi All,

can we join ( in a single query ) two tables each residing on separate Databases using Datastage Teradata stage.

Eg:
Table 1 resides on DB1
Table 2 resides on DB2

Can we join these two tables with a single Teradata stage ?

Regards,
synsog

Hi All,

Can someone share details/related documents to understand SAP Plugins/Stages in Datastage ?

Thanks in Advance!

Regards,
synsog.

Thank you all for your valuable inputs. Passing Numeric using two different Parameters resolved my issue.

InputColumn[Param1,Param2]

Dear Experts, In continuation of this old topic, I am having difficulty when passing the Numeric part through a Run-time Parameter. I am not getting expected output in this case. Value of "Parameter-1=1,4" (Defined as DS JobParam) DSLink149.INTFC_FILE_CATG[Parmeter-1] i am getting a output...

Hi, Im using DB2 connector as look up to transformer and using SQL inside the connector for look up. when i run the job, the get the error "DSP.OpenGCI $DSP.open error -100" and a warning "schema reconciliation failed : the column names defined on the link donot match with that of the...

actaul errors: xmlSrcReadXmlFile,0: Caught unknown exception from runLocally(). xmlSrcReadXmlFile,0: The runLocally() of the operator failed. xmlSrcReadXmlFile,0: Operator terminated abnormally: runLocally() did not return APT_StatusOk xfmPassXmlFileName,0: Internal Error: (shbuf): iomgr\iomgr.C: 19...