DSXchange

Thanks for the update
That is exactly what I did. copied the file locally and loaded this file. no problem occured in any stage.
trace was activated in ftp stage properties
Best Regards, Guy Przytula

The file on remote node is accessible with ds, because if I specify fix length fields no. I can see that the complete record is extracted and truncated
Data is displayed
Thanks for all update

Is it possible to specify commicount in DB2 API stage or is this after each insert ?
with db2 load savecount can be specified.
Thanks for all help
Best Regards, Guy Przytula

Trying to use ftp as input stage defined connection/port/filename It is possible to use interactive ftp I am getting this message when running the stage : ICPC_FTP..Transform_dates: Internal error: function 'buffer_to_row' failed ICPC_FTP..Transform_dates: Unable to retrieve column from link Any ide...

we have a job that reads a sequential file and inserts this data to a db2 database. we have been using an odbc stage (on windows to test) the data contains date fields (20031231) defined in source file as character 8 with fixed length fields, which we transform to 2003-12-31 before inserting in the ...

We have defined the dsadm (ds administrator) as a db2 client and cataloged a database. we can connect from cli from this user to the db. when defining a server job and specifying the same database name, we get an error that the database name can not be found sql1013n ICPC1..DB2_UDB_API_5: [IBM][CLI ...

Thanks for all update
Yes : we need connection to db2
No : I was pointing to this : the db2setup.sh can NOT be located in the installation directory of DS.

Is $APT_ORCHHOME the installation directory ?

what is meant by PX ?

Best Regards, Guy Przytula

Just installed DS server (ent.ed) on solaris. according the doc : ds install upgrade guide - you need to run the db2setup.sh script. I could not find this script in any directory Are we missing any part ? I see many entries in forum about ENV setting, but could not find this in the doc. Any hint abo...

I want to manipulate some fields in a before routine, reading the input file and creating output files. These fields are DEC Compacted EBCDIC. Any idea how these can be checked, for specific values and put back another value to this fileld, that is still compatible with EBCDIC DEC COMP-3 The problem...

Running a server job on an EBCDIC input file There are some decimal compacted fields in this file : pic s9(13)comp-3 There are fields with different length 13 - 7 Sometimes, this field contains 404040 instead of real deximal data. As 404040 is also accepted as compacted decimal, the target table is ...

Anybody any idea, if a column of the datafile can be used to indicate the nbr of occurances of the next structure in the file : 0 to .... ??
Thanks for all reply

First question (and not the last) from new user. We have received EBCDIC files on Solaris and/or Windows platform. that are cobol cpybook defined files - this file has varying records and are streamed (no cr/lf). the first record of 540 bytes (fix) is always included and keeping general info. this r...