DSXchange

If you had a premium membership you would have at least two solutions already. I posted complete solutions. The funding model for DataStage - what keeps it alive - is premium membership (notice the lack of advertising?). There are five identified "premium posters" - acknowledged experts wh...

You should be able to see it enabled once you've tested the DRD.

Tapes can be a little more problematic due to their blocking factor but, if the conditions Arnd referred to are met, then it should be doable, though you might have to create a routine for the preliminary de-blocking.

Use a sequence that reads the file, parses the parameter values, and supplies them to the job through a Job activity.

Learn about membership benefits and get premium membership here.

You may need to re-install Information Server. That having been done, you can restore from your backed up jobs.

Trim the leading "0" characters and trim the trailing "." character.

Try using a freeware client such as SOAPui to see (a) if you can access the web service from your DataStage machine, and (b) what the WSDL looks like.

Sura's intervention raises the possibility of needing to handle the possibility that "first line is column names" is asserted, in which case an "empty" file will contain one line. The usual technique in a DOS batch file is to count the line terminators. set file=textfile.txt set ...

chulett wrote:Well, heck, of course - the z modifier! Why didn't I think of that?

Actually I believe the correct terminology is the "z specifier".

1. Set your PATH environment variable correctly, or
2. Specify the full pathname of the sqlcmd command.

You can, of course, test for the file size in a DOS batch file which you might invoke via the ExecDOS after-job subroutine. You can find the technique more fully documented in DOS help or via an internet search. In essence the technique involves simply using the z modifier for a FOR variable referen...

Actually it's the STATUS statement, rather than the System() function, that you need here. This statement returns a dynamic array of information about the file whose file handle is provided. The following example code has minimum error handling, for purposes of clarity. SUBROUTINE DeleteIfEmpty(aPat...

You might even countenance using a Survivorship rule to accomplish that, such as "most frequently occurring non-blank".

Both OLEDB and ODBC are possible. Try an internet search for "arcgis database ODBC connection". Then be very selective - most of the hits relate to connecting to databases from ESRI ArcGIS.

Might your requirement be met by a "push" solution?