DSXchange

Thank you to everyone who has had input in assisting me to resolve my problem.

My job is working successfully now.

Thank you so much !

Kind regards,
Barbara

Hi there I putting in the code you just sent me ... it has put the commas in between the file names now - BUT when the job runs, it's still processing ALL the files output by the UserVariable Activity Stage as ONE file name instead of splitting them up in the Start Loop Activity. This is what the IN...

This is the syntax of the command I am executing;

DIR /B/O-D "\\mcbcptfs01\groups\MHD\Data to load\Payroll files\TRANS files\*.csv" ls -m

Is this correct ?

Hi there Thanks for all the responses. Thing is that I have other team members working from home without this issue .. so I am assuming that it is on my VPN settings side perhaps ? I cannot remote login to the server because that is restricted and controlled by passwords. i will have to go home and ...

Hi there I use ADSL from home and vpn into my office to do some Datastage work. Everything was going fine until about a month ago when I tried to save something and the save failed with an error reffering to a "Could not save TableDefs". What does this mean? And what can I do to solve this...

Hi there Ok, firstly, I'm passing a user variable for the file name to the job each time the loop iterates. So every time we go through the loop, the name of the file is processed by the job by the user variable. That is done. HOWEVER, this is still the problem I'm experiencing. My job looks like th...

Hi there guys, Thanks so much for trying to help me ... but clearly I've lost the plot here. Can someone tell me where does the User Variable stage get the values for the user variable ? When I add it to my sequence job, there are no options for me to add user variables. I'm looking through my helpf...

Hi there I have a job that uses an input file parameter - the problem is that the input file parameter will have a different value as the job loops through each of the input files. There are approximately 20 files in a windows directory. My sequence job has a startloop activity stage and then an Exe...

Hi, Has anyone experienced the following problem and have found a possible solution to it? In a simple transformation job (DB2_UDB_API_In > Transformer > DB2_UDB_API_Out) there is an issue whereby the job claims to run successfully and it looks like the rows where processed properly (i.e. green link...

Greetings, I need to prove in a POC that DataStage can move blobs between Informix and SQL Server in a bi-directional manner... I have not done this before but after doing some research on the net - I have found a few documents and sites stating that the new connector stages has this functionality.....

Problem was solved.

The location of the oracle client specified in dsenv was different to the one used by tnsping. changed the dsenv paths and solved the problem.

Where do I find documentation on the cofiguration of connectivity to Oracle? I am running IIS 8.1 on AIX and I need to connect to Oracle 10G. The Oracle client has been installed on the IIS server. I can TNSPing the oracle db I need to connect to, so my TNSNames.ora file is fine. Why is this documen...

I am using a ODBC stage to connect to an External application. In Project1, I am able to connect to the application and extract the data, but in Project2 there is an issue with the connection with the following message. main_program: Fatal Error: Could not connect to datasource[DataDirect][ODBC lib...

Greetings, One of our clients are doing a migration project and need to move more than a thousand tables from an AS400 on a iSeries The problem is that the AS400 has technical field names - and when they import metadata to use in DataStage the description column is imported as <none> which in the da...

I logged on to the system with all the users - none of them are locked or disabled...