DSXchange

My question concerned record size, not file size.
IE Would there be any problem processing a CFF record(COBOL) greater than 160500 bytes?

Thanks,

Ande

Is there a maximum record size for CFF or sequential flat files? I haven't been ablt to find anything on record sized, just file sizes...

thanks,


Ande

I/we use osh extensively. It's the fastest way to move huge tables from one server to another: write a .ds from the table, parallel scp or ftp from one server to another for each partition of the .ds, and read the .ds into the table. Of course the two servers have to have the same partition setup. O...

Also make sure you have write permissions in the scratch directory.

Ande

If you're talking about keeping track of various versions of datastage jobs, you can always put the .dsx into the version control system.
If you're talking about doing baselines and merges, then you have to wait for the version after Hawk.(Or later).

Ande

Did you verify that the sequencer has the parameter defined and is passing it
'as is' to the job?

Ande

alphac wrote:
so suggest you to use space(10) to represent null date instead of empty
string. Since you could re-use the generated sequential file by Datastage.

That only works if the recipient will accept that. And won't.
nulls work.

This is actually on AIX 5.2, if it makes a difference.

Ray, or other, do we know what DS does differently when '' is specified instead of "" for a default value? I know what the difference is in C and C++, but not sure in DS/PX.

thanks,

Ande

This could be any number of issues. There is a limit on the name size for stored procedures in UDB, and if you have 2 or more procedures with the same name in the first(I think 15) characters, the system may not be able to find your procedure. Make sure you have a procedure created with the same num...

If it's UDB, you can use load for the inserts.
If not or otherwise, your best bet is a custom op.
either through datastage or command line/scripted osh.

Ande

Check the permissions on the configuration file....

Ande

Is there not an optional "Decimal Type" property where you can set precision and scale? I've worked at banks for most of my career. From a Savings Bank to the NY Fed., all use 'decimal' types for dollars and cents, and all calculations are done BCD. It's probably one of the greatest reaso...

I use osh all the time. I have a local connection, so that makes things very easy. One common use is a script that moves a DB2 table from one server to another by exporting(db2read) to partitioned datasets, FTP/NDM/SCP the data sets from one server to another concurrently(big pipe), and then load us...

I've never successfully entered the shell using uv, I always use uvsh. If I just key in uv, I get the same error message. If I key in uv -admin [option] everything works fine.

Ande

Is it possible to install/run two different DS Servers with different versions, say 7.0 and 7.5 on the same machine? How about clients? Is migration from existing DS7.0 jobs to DS7.5 handled automatically by the latter? gateleys You can, but you have to change the daemon to look at a different addr...