DSXchange

Ah, you've been poking around. :wink: No, don't delete anything. And you need to add "-64BIT" to the command so it creates a 64bit hashed file. The resize command doesn't use the dash, this one d ... Thank you very much chulett, that worked! ps: I contacted my manager to renew our members...

Then you are not at the command line, which means logged in at the O/S level. You are still trying to run this from TCL or the Administrator client. Don't. ... Ok i managed to execute the command. The result is that there is created a directory and 3 files in it. Do i need to delete the file in the...

A) You need to run it from the command line, not TCL. B) Do not include the "Creating file DeclDet1, executing command " verbiage, just the command itself. :? ... I use the command line and the command /appl/dstadm/IBMIS/Server/DSEngine/bin/mkdbfile /appl/dwa00p/hashed/amf/dwa_ulb_azkr//D...

Ok i got that now. But the issue now is if i use the command: Creating file DeclDet1, executing command /appl/dstadm/IBMIS/Server/DSEngine/bin/mkdbfile /appl/dwa00p/hashed/amf/dwa_ulb_azkr//DeclDet1 30 1 4 20 50 80 1628 64BIT It returns: Verb "Creating" is not in your VOC. I dont have acce...

The VOC record depends on how you create it. For a pathed hashed file, use the mkdbfile command you'll find in any job's log that has created one for you. ... Yes it uses a pathed hashed file. In the log its says: Creating file DeclDet1, executing command /appl/dstadm/IBMIS/Server/DSEngine/bin/mkdb...

thats a good idea, i thought we had a premium membership, but i will check it.

But one more question. If i create a new hash file, i see that there is also a voc file that is created. Do i need to do something with that file?

Hi Aninas, When you are On 64-bit Unix you can manually create the hash file(s) from Administrator: 1. Log into DS Administrator, Projects tab 2. Select the project and click Command... 3. In the command line, type: CREATE.FILE FileName 30 64BIT If u want all your hash files will be over 2GB, then ...

The stage only creates 32bit hashed files for some reason. You'll need to create it one time as 64bit from the command line and then have the stage simply clear it. A before-routine could emulate the ... It says premium content, so cant read the rest. So the solution is: RESIZE hashedfilename * * *...

Thanks for your reply.
How can i convert the hashed file to 64-bit? And i have the next options checked:
-Create file
-Clear file before writing
-Delete file before create

If i convert the file, after restart, the job will make a new 32-bit file, or am i wrong?

Im getting an error for an serverjob, which is using a hash-file. The hash-file size gets bigger then 2 gb and gives me the next error: ds_uvput() - Write failed for record id '35612396' Message: DataStage Job 35 Phantom 4298 Program "JOB.1056046522.DT.1583741912.TRANS2": Line 123, Interna...

pavans thanks for the reply, but i don't use the manager to export. i am using the export script from Duke.

pavans wrote:While Exporting the Job, You can check Job Executables and select the job from the list. Once you import, you will see the job in compiled state.

KDuke Thanks for youre reply, but it's still not working. I have the following syntax: for /F "tokens=1" %%i in (%DsxList%) do ( ECHO Importing %%i to Project: %Project% on Host: %Host% echo %DSImportCmd% /H=%Host% /U=%User% /P=%Password% %Project% %ProjectDir%\%%i >> %LogFileName% %DSImpo...

How to get a runable job after a export? I have a server job exported but it is not runable, i must first compile this job before i can run it! is there a option when i export the job so that it wil be a runable job so i don't have to compile it? I am using dsexportcmd.exe to export. Please advise

Hi, I am trying to export a DS routine(SourceFileSearch Routine) with the DataStageExport.bat from Kim Duke. However i get a the next error: 'Job SourceFileSearch does not exist in this project'. I am not sure of it is possible to export a routine with de dsexport.exe command. Someone suggestions? T...

Hi Guys, i have a little problem, when i try to import a dsx over a project i get: Error calling subroutine: DSR_JOB (Action=9); check DataStage is set up correctly in project test (The connection is broken (81002)) It's not a connection issue because i have removed and created de project serveral t...