DSXchange

kcbland

Style points count

I have an unfair advantage having programmed in DS BASIC since 1988.

kcbland

Running jobs slow down the response time on the node that houses the job repository. The increase in jobs may be an indication that more work is being done on the server, and thus response time decreases. If no one is executing jobs, then the response time opening a Designer session should be reason...

kcbland

No, write a DS function to do the work on a passed string. Something like this should work:

Code: Select all

StrLen=LEN(Arg1)
Ans = ""
For i=1 to StrLen
  Ans := SEQ(Arg1[i,1])
Next i

kcbland

What is your target stage type, because we can't answer you correctly without that information.

kcbland

Let me get this straight: 1. job #1 truncates the table and puts data into it 2. job #2 is supposed to insert or update existing data After running job #1 you have data, but after running job #2 the table is emptied first and then only rows from job #2 are inserted? Please verify the table is truly ...

kcbland

Are there triggers on the target table, or anything that would delete rows?

kcbland

Please paste your derivation for the stage variable.

kcbland

Which stage are you using, ODBC, Oracle OCI, DB2, Informix, Redbrick, etc?

kcbland

No matter what, you need a cross-reference between position in the csv file and the code. Since position 1 is Spanish, 2 is English, 3 is Hindi, 4 is Kurdish, etc, you should create a table for maintenance purposes. In this table, I suggest you have the position number, text name, and language code....

kcbland

Look at the mkdbfile command that is issued when a DataStage job creates a hashed file. Add 64BIT to the end of the syntax line and you'll get the same file only with 64BIT addressing. Just put that mkdbfile line into your jobstream and execute when appropriate.

kcbland

42 minutes

kcbland

Using a Sequencer a Routine stage can call your script, or in Batch a CALL DSExecute(...) will return the screen output and return code of the script. Choose your weapon.

kcbland

You're fine on Windoze but on Unix it's selectable by your Admin, believe me, I've got 100GB+ files lying around...

kcbland

Sorry it took so long and so many questions

Need more coffee...

kcbland

I've not seen this issue, I guess you'll have to wait for Ray Wurlod or Kim Duke to answer, they're the experts on the internals. There's nothing special with the filenames. If it's just this one name, it could be that there's a Windoze lock on the filename, or potentially if it's an internal hashed...

Search found 4992 matches