DSXchange

Found out that we can use the below environment variable in the job to capture the records with fields that run over the defined limit in metadata. $APT_IMPORT_REJECT_STRING_FIELD_OVERRUNS=True https://www.ibm.com/support/knowledgecenter/en/SSZJPZ_9.1.0/com.ibm.swg.im.iis.ds.parjob.adref.doc/topics/...

Hi , I have a sequential file which is pipe delimited that has around 300 fields. Each field has field width specified as well. For eg: Gender varchar(1). I want to capture the rows that violate the field width. For eg: If I get gender value as "M*" , currently the sequential file stages r...

We have applied Fixpack 1 in our environment and our Data Governance team is running column analysis without any problems. In addition to the Fixpack, we had to apply an additional patch. Not sure if the patch fixes the IA issue or not. The Patch # is JR55954.

Thanks Ernie. This is how we are proceeding. I appreciate the information.

I am creating a parallel job that calls a web service. The service developer provided me the WSDL which I successfully imported into DataStage using the Web Service Meta Data Importer. I then created my job, using the Web Services Client stage as my input. I was able to select the web service operat...

In your Else statement, you are setting the date to 4444-01-01. The input date is not valid. There are only 30 days in April. It is working as you designed it.

Your main problem is that you are missing the "%" in front of the mm.

Per the editor's post above, that should be editor@dsxchange.NET

See if this helps:

http://www.ibm.com/developerworks/data/ ... index.html

We have a problem when we are importing FTP stage jobs from Information server 8.1 to 8.7. There are no values set in 'Format' tab of FTP stage in Information server 8.1 but when we import into 8.7 it automatically setting final delimiter, Delimiter and Quote to default values which we do not need. ...

It's possible the dialogue box is opening off-screen. Try these steps to see if you can move it back:

1. Press Alt-tab until you are on the screen that won't display
2. Press Alt-Space
3. Choose M for Move
4. Use the arrow keys to move it on to your monitor

When you say you are writing data to files, are you using the Sequential File stage? If so, you can just append the system date parameter to the end of your file name: /path/FileName_#DSJobStartDate#.txt

Convert() replaces single character by another single charcter. I have seen this posted on DSXChange before, but I have not found it to be true. I ran a quick test, using the "Convert" solution and found it worked per the o/p's requirement. Is it possible this is how Convert worked in ear...

What version are you using? As I remember, the DB2 Connector was first available in 8.1, but had bugs until FP1 came out.

We have seen this problem when the window is opening off of the screen. This usually happnes in dual-monitor situations. Uninstalling and reinstalling will fix the issue. You can also search the forum for steps to fix the problem by cleaning up the client's registry. Or, sometimes you can attempt to...