convert 32bit hash file to 64 bit

lak4u · Post by **lak4u** » Wed Oct 07, 2009 9:13 am

Hi,

Can we convert 32bit hash file to 64bit? our server is on 32 bit windows
Please help

Thanks

ArndW · Post by **ArndW** » Wed Oct 07, 2009 9:57 am

From the TCL command line or from your admin, execute "RESIZE YourHashedFile DYNAMIC 64BIT"

lak4u · Post by **lak4u** » Wed Oct 07, 2009 10:13 am

ArndW wrote:From the TCL command line or from your admin, execute "RESIZE YourHashedFile DYNAMIC 64BIT" ...

Thank you very much, can I know the command? Itried with below..

"RESIZE hsh_Staging_3 DYNAMIC 64BIT" but got message like..

"Invalid file name ,sizing parameter,or option on command line"

Thanks

ArndW · Post by **ArndW** » Wed Oct 07, 2009 10:40 am

Did you create "hsh_Staging_3" as a local file in the project or as a pathed file. If the latter, you will need to make a local file pointer to that file. The "SETFILE" command will do this for you, for instance "SETFILE SETFILE PathToYourHashedFile TempHashedFile" then "RESIZE TempHashedFile DYNAMIC 64BIT"

lak4u · Post by **lak4u** » Wed Oct 07, 2009 11:14 am

ArndW wrote:Did you create "hsh_Staging_3" as a local file in the project or as a pathed file. If the latter, you will need to make a local file pointer to that file. The "SETFILE" command will do this for you, f ...

Thank you again. I am not clear about local file and pathed file.I really appriciate if you could explain

Thank you

lak4u · Post by **lak4u** » Wed Oct 07, 2009 11:17 am

ArndW wrote:Did you create "hsh_Staging_3" as a local file in the project or as a pathed file. If the latter, you will need to make a local file pointer to that file. The "SETFILE" command will do this for you, f ...

Thank you again. I am not clear about local file and pathed file.I really appriciate if you could explain

Thank you

chulett · Post by **chulett** » Wed Oct 07, 2009 11:18 am

Is your hashed file in an "account" or "pathed" into a specific directory?

lak4u · Post by **lak4u** » Wed Oct 07, 2009 11:24 am

chulett wrote:Is your hashed file in an "account" or "pathed" into a specific directory? ...

Its a spacific directory like ..

C:\Ascential\DataStage\Projects\Exp_Compliance_DEV\Hash_Files\

lak4u · Post by **lak4u** » Wed Oct 07, 2009 11:56 am

chulett wrote:Is your hashed file in an "account" or "pathed" into a specific directory? ...

Posted: Wed Oct 07, 2009 11:24 am

--------------------------------------------------------------------------------

Its a spacific directory like ..

C:\Ascential\DataStage\Projects\Exp_Compliance_DEV\Hash_Files\

Can you please explain what I need to do ?

Thank you

chulett · Post by **chulett** » Wed Oct 07, 2009 12:49 pm

As noted, in that case you need to create a VOC record for this command to work. Use SETFILE for that, the syntax can be found here by searching.

ray.wurlod · Post by **ray.wurlod** » Wed Oct 07, 2009 7:48 pm

The correct syntax for RESIZE is

Code: Select all

RESIZE hashedfilename * * * 64BIT

in its simplest form. You can specify an alternate file system for the temporary intermediate copy with

Code: Select all

RESIZE hashedfilename * * * 64BIT USING pathname

where pathname is the pathname of a directory in a file system with at least 2.2GB free space.