DSXchange

Please ask a specific question. You've asked us something akin to "What's the difference between Windoze 2000 and Windoze XP?" We can answer: Nothing. Both are graphical operating systems with lousy security. Or: Where do we start? User experience, networking, routing, security protocols, advanced g...

That would be why hashed files have neat things like caching and such. It permanently records a dataset for repeated high-performance reference capabilities.

naren6876 wrote:Actually iam expecting a file with Line Terminator either fixed width or variable width.So,How can i put a Line terminator if I dont receive it in the file?

Then 2 lines run together as 1 line? How do you know where the first derived line is separate from the second if they're variable width?

Just as a side note, I had an interesting experience the other week. I installed some software on a laptop at a customer site that uses roaming Windoze profiles. They gave me a workstation later in the week so I had two machines. When I logged onto the workstation, my roaming profile downloaded and ...

I think you mean "tracing". Probably not helpful. You need to get a network admin to look at what is going on with a Designer session when opening a job. We've pretty much eliminated a contentious server environment and now the focus is the network. Are there collisions, is your firewall causing pro...

Parent-child relationships between sets of data, the Lookup stage is documented in your manual.

3 output links from a transformer, use a link collector, turn on Inter-Process row buffering.

Are there supposed to be line terminators or not? The first 100 chars of each line means that each line has a terminator, because you are saying LINE. If there are just 100 char blocks of data, then there is no concept of a LINE, thus a line terminator will mess things up. Either you have line termi...

Should the file be fixed width with end of line terminators or no end of line terminators just 100 characters per "record"? There's a big difference. I don't possibly see how you can fix a file under either circumstance.

From the beginning I've said consider the project lost and take the safe route.

You're saying the column definitions are in a mapping file, and you need to parse a data file according to the mapping file. The issue is that DS wants a fixed set of column definitions to use the Sequential stage. You MUST have a fixed set of columns, and the only issue is finding the parsing value...

I would love to help I just can't figure out what you're saying. Could you please show a small amount of data from each file? How are the files related, meaning is it by a foreign key or such?

mkdbfile is the version for Unix or DOS command line and creates externally pathed files. From the DS Admin or TCL prompt you could use CREATE.FILE for internal project hashed files.

The good news is you still don't know the extent of corruption, did it cause referential integrity issues with other storage tables. You're wasting time when you should have just recovered the project as I recommended earlier. You could have job designs that are missing, unable to even open, etc. Th...

If your job has an open cursor with a selection set using a rollback segment and the job fails, the process ends, and the rollback+selection set are released, how could you possible re-enter processing exactly where you aborted when the selection set in the rollback has been released? You program in...