DSXchange

lak4u

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\H...

lak4u

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

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 ...

lak4u

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 ...

lak4u

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 com...

lak4u

Hi,

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

Thanks

lak4u

Hi, I have been with same error,can you please share how did you resolve this? Thanks HI, Can some one tell me what is this warning about? We are getting this for inserting data into HASH file. Computed blink of 0x890 does not match expected blink of 0x0! Detected within group starting at address 0x...

lak4u

Hi,

I need to Find any letter in string value

if I find @ in string value I have to put whole string in quots.
exaple: AB@DEF then "AB@DEF" else AB@DEF

but I couldn't find any FIND function which finds letter in String.

Please help

Thanks

lak4u

asorrell wrote:Easiest way is to use a Before Job ExecDos command to copy a csv file with five empty rows to the correct filename before you start your job. Then have your job append to the file instead of overwriting it.

Hi Andy and Craig

Thanks for your answer.

lak4u

Hi,

I need to create .csv file but I need to leave first 5 rows as empty and load it from 6th row.How can I leave first 5 as empty rows?

Please help

Thanks

lak4u

ArndW wrote:DataStage is backwards-compatible, but not necessarily forwards-compatible. You can do an export in V8, then edit the .dsx file so that the header information shows the one required for V7 (I'm not a ...

Thanks for reply.Your message was missing,please send me again

thanks

lak4u

I want to know if there is any why to move DataStage 8.1 projects to DataStage 7.5.

I know we can migrate from DataStage 7.5 to DataStage 8.x but I need rverse. Please le me know if anybody knows

Thanks in advance

lak4u

I don't have access to DS or the manuals, but I kind of doubt your 1900000 addition/subtraction - that number looks wrong. Where did you get that and are you certain it works? ... Thanks. I am not sure about this 1900000 but is showing currect result FOR JulianDateToDate I am able see currect resul...

lak4u

chulett wrote:Broken formatting tag, ignore it. Should have looked like this:
Code: Select all
OCONV(ICONV("2009-04-06","D4-YMD[4,2,2]") -1900000 ,"DJ")
...

I tried this.I got value "114"

lak4u

ArndW wrote:Have you tried the inverse function,

Code: Select all

OCONV(ICONV("2009-04-06","D4-YMD[4,2,2]")[b]-1900000[/b],"DJ")[code] ...[/quote]

I tried this and got value "114", I never used inverse function,can you please tellme the how to use this [code]?

Thaks

DSXchange

Search found 42 matches

convert 32bit hash file to 64 bit

Re: HASH file error does not match expected blink

Find any letter in string value

Excel spreadsheet load

Moving from DataStage 8.1 to DataStage 7.5