DSXchange

Edit the parameter set and click Add Environment Variable. The button is near the bottom of the parameters tab.

I just noticed an official announcement.

I have posted a link under this topic:

Information Server 8.5 and 8.7 End of Service Dates

Information Server 8.5 and 8.7 End of Service Dates Information Server v8.5 End of Service Date: September 30, 2016 Information Server v8.7 End of Service Date: April 30, 2017 Please follow the April 14th, 2015 Announcement link for details: http://www-01.ibm.com/support/docview.wss?uid=swg21699049...

It would appear remove all occurrences of a double quotes. It also has a lot of extra "stuff" in the function call that is not needed. Use Notepad or code tags to see: Trim(columnname,("":'"':""),"A") ... and should be equivalent to: Trim(columnname, '&qu...

Try changing into the $DSHOME directory just before running the command.

Timeout errors are sometimes caused by firewalls blocking the connection.

I would expect it to call the script every time. Test it and find out.

I'm not sure about 9.1; I skipped that release. Try searching the IBM Knowledge Center on "Workload Management." There is probably a config file you have to edit on the server. I vaguely recall that the feature is off by default on 9.1, whereas it is on by default in 11.3.

Do some searches on the "dsjob" command. It has a report option.

Welcome aboard! There are several options. A few of the options include: - Open the job in Designer, File menu, Generate Report..., you get a nice looking web page with job name, job design image, and details. It is printable as well (i.e. print as a PDF if you have installed a CutePDF driver). - Op...

It seems like if you right click in any expression editor and choose DS Macro, there is one for project name.

Well by all means, sign up. It's incredibly affordable.

In the job that writes to the Data Set stage, experiment with using different numbers of nodes in the config file. How many nodes is it currently running on? You may also want to check with your server administrator and/or storage team, if you have one. Find out exactly how slow those disks are writ...

I simulated a small test of this in IGC 11.3.1 with RU8, with workflow enabled, using Firefox. Under the list options, I can choose to view 10, 50, or 100 at a time. Choosing 100 at a time may help with productivity. In the Glossary Development, menu: Glossary -> Development: Draft Assets view: on a...

You could use the ODBC Connector stage with the ODBC DB2 wire protocol driver. It does not require a DB2 client to be installed, but it does require an ODBC data source to be defined in the .odbc.ini file. I have heard that newer releases, such as DataStage 11.3.x, also allow for using JDBC connecti...