DSXchange

milind wrote:Can anybody please reply on this one soon.

Thanks

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

I'm working on a 5.2 site this week and can't answer the question.

Yes, but why would you want to?

Simply put, you can read the file with a Sequential File stage set to read 80 columns, pipe delimited. In the Columns grid in the Sequential File stage scroll to the right and change the missing columns rules for columns 11 through 80 from Error to Replace (work from the bottom up; there is a hierar...

This looked like it was working, but I have recently found out that not all of the data is being pulled over. The Unidata field is multi valued, does this affect the selection statement? Yes it can, depending on what columns (fields, in UniData parlance) you're extracting. If you want to limit the ...

Yes, there is. YOU control it, with the specification in OCONV. For example:

Look in the Status view in Director. You should see three jobs. Batch::Job1 Batch::Job1. Instance1 Batch::Job1. Instance2 You can switch to the Log view after selecting any of these, and see the events just for that instance. (It this is not the case, there may be some special way that job names sta...

No, but it's the safest and, imho, the quickest. The "official" way is to examine the magic number of DATA.30; there's a bit set in there to indicate whether 32-bit addressing or 64-bit addressing is in effect. You can also inspect it with things like hex editors such as filepeek but I'd counsel aga...

Show us the exact command you put in the Input Value field when you used ExecTCL. I've done hundreds of these. Also tell us why you believe it didn't work, and post the detailed log event generated by ExecTCL. Please start a separate thread for the question about executing multiple commands via Exec...

How can I create a universe table directly in Designer with Universe Stage?? Because I don't have the administrator access. You don't need administrator access. In the UV stage just check the "create table" box. You can even use the Administrator client, even though you don't have the admin passwor...

Interestingly, or not, lunch today was the misspelled "Geek salad".

The space character in data is just another character. It should not generate any problem in retrieving data. Your data browser never tries to insert anything. The error message is not occurring when you're browsing the data. It's occurring when you run the job, when the job is trying, somewhere, to...

CREATE TABLE and CREATE INDEX statements can be executed from the Administrator client's Command window. CREATE TABLE can, alternately, be executed automatically by the UV stage, but you don't get your columns indexed.

Set your data source to localuv.
The user and password fields are then disabled, because DataStage is automatically connected to the localuv data source.

If the hashed file already exists, you can access it using a UV stage without making any other changes. If it doesn't exist, and you use a UV stage with "create table" checked, what you get created is a hashed file. That is, every UniVerse table is a hashed file. The UniVerse database uses hashed fi...

You can not insert rows into a hashed file without supplying a value for the key column. Exception: If the hashed file was created as a UV table with automatically generated key column, you can. I expect that this is not the case here. How? CREATE TABLE tablename ( PKCOL INTEGER NOT NULL DEFAULT...