DSXchange

We had a similar issue and resolved it by setting $APT_DEFAULT_TRANSPORT_BLOCK_SIZE = 262144

Ok, so you use internet explorer to connect with http//isserver:portnumber

This should give you a login prompt.

Login as isadmin (no space).

Do you get this far?

Try logging in as isadmin

A few relevant questions. Was this a new install or an upgrade? Are you connecting with user isadmin? What is the URL you are attempting to connect with?

Got a possible solution to CFF COBOL write problem.

At the CFF level stage, Record Options tab, Set the Byte Order as Big-endian...

Web Console Configuration after Installation:

Open the Information Server Web Console at
http://***.com:9080/ibm/iis/console

1. Add dsadm as administrator and give all accesses to this user.
2. Share the server credentials

Craig already suggested you read the data as 1 column in a string and process it in a transformer. Is there a problem here?

If you method is sort then datastage can release the grouped data as soon as it is processed. This is far more efficient.

If you publish your server routine, I could see your rule base and translate it into PX for you. An example transformer algorithim using the INT and MOD functions:

* (YYYY-MM-DD)
YEAR = ExtDate[1,4] + Int((ExtDate[6,2] + #MONTHS#) / 12)
MONTH = Mod((ExtDate[6,2] + #MONTHS#), 12)

I installed FixPack 1 on client and server for 8.5 but still got the error. Eventually I copied libclntsh.so.10.1 from $ORACLE_HOME/lib to $ORACLE_HOME/lib32 and this fixed it.

Have a look at the Row Generator stage. This will allow you to generate as much data as you like and you can modify it in a transformer to lookup against your flatfile data.

Modulus is a keyed partioning method where rows are evenly distributed according to the values in one integer key column i.e. partition = MOD(key_value / @NUMPARTITIONS) This is quicker than hash which uses cyclic redundancy check

Use the dcount function to establish how many occurances there are of your substring e.g. dcount(''dog cat dog cow dog'',"cat") will return 2

A nullable column in a sequential file? Give me a break.

I guess in a transformer you're looking at something like:
if NullToZero(Aggregated.ITEMTOT) + 0 then 0 else Aggregated.ITEMTOT/Aggregated.ITEMTOT