DSXchange

Bottom line is the fact that any delimited file needs to have the character fields quoted if there's any chance of the delimiter appearing in the data. And let's not even talk about the choice of quote character - it can't appear as data in the field either.

As noted, that's not a valid csv format file - assuming you've put pipes where the commas between fields were. It should look like this: 11,"023","F Customer observed smoke & a burning smell. Worn mixer motor with a locked rotor, and possibly an internal short circuit that burned a 10 ohm 1W car...

What version are you running? Have you contacted Ascential support and asked them this question?

Sounds like you've got an invalid csv file. Are your string fields properly quoted? Best answer would be to push this back on whomever created it for you and have them create a valid file.

Can you post a couple of the offending records here?

No. We do something similar in many places and don't have this issue. Out of curiousity, what 7.x version are you running?

I forgot about this. We were running our jobs as 'always on' jobs, without allowing it to automagically start new invocations if it needed to. For whatever reason 'they' wanted to stick with that always on approach so we bumped the number of simultaneous invocations up to 2 or 3 depending on the ser...

The general rule we have, regardless of tool, is to drop the bitmap index before the load and rebuild it afterwards. Had too many problems leaving them in place during any kind of load of a table with that specific index type on them.

kduke wrote:He said it was a custom stage. Has to be PX.

Well, apparently there is a Server version on the Windows platform, as Ernie and others have confirmed. Don't know about the 'custom' aspect of it at all, so perhaps both answers apply. [shrug]

Why should I write it all up again when it's already in the FAQ Forum as I noted? Here is a direct link:

http://www.dsxchange.com/viewtopic.php?t=88639

Start there and let us know if you have any questions after you've tried to implement it.

And in your spare time, install the Pivot stage.

Just getting tired of all the pleading... the whole point of this place is helping others, people don't need to end every post with a plea for help.

Hang tight, be patient, you'll get whatever help people can provide when they can provide it... no groveling required.

Far simpler to install the stage and use that, then it would be all automagic. I don't recall it being one of the 'optional' plug-ins but seems like it must be if you really don't have it. Check the FAQ forum, there is a post there on creating multiple rows from a single row with a couple of differ...

Pivot stage does columns to rows, check it out.

That fact has already been established. Now we're trying to move on to the 'how helpful' stage.

However, as I've only ever played the UNIX version of the DataStage game, I can't really help there either.

They seem to have tried both with no joy.

That's interesting - thanks Ernie. So, does the thing work? Still supported? Ship with documentation?

Please Guru help me.