DSXchange

The hashed file will either need to have been created in an account, or a VOC entry created for a 'pathed' file using SETFILE, in order to use this command. ... I've created the hashed file in my path and also have added the command in DS dictionary. I've executed the command in the path where the ...

Oddly enough, that is the command you would use. ... When i tried to use the command thru UNIX box, i got an error saying that, 'ANALYZE.FILE' not found. So it means that the command is not present in the data stage dictionary list (Kindly let me know if i'm wrong). So how do i can add the command ...

Moderator: please move to server forum ... Ray, Kindly apologize me for posted the topic in wrong place. Could you tell me how to move from parallel to server forum? (Dont get irritated as i'm asking a silly question. As i haven't came across this kind of situation, i didn't use that yet. Thats why...

Oddly enough, that is the command you would use. ... When i tried to use the command thru UNIX box, i got an error saying that, 'ANALYZE.FILE' not found. So it means that the command is not present in the data stage dictionary list (Kindly let me know if i'm wrong). So how do i can add the command ...

Hi all, Do we have any command to analyze the hashed file struture through UNIX box like ANALYZE.FILE <File name> in UNIVERSE fILE STRUCTURES?Kindly forgive me if i mentioned anything amiss. Because i'm not aware about UNIVERSE fILE and all. Your time will be highly appreciated. Thanks in advance ve...

ray.wurlod wrote:In Director Schedule view or through inspecting the crontab entries for the DataStage user. ...

Could you pls. explain about 'crontab' entries for DS user?I'm not aware of it. Jus wanted to know in detail thats why.

Thanks,
Veera

qutesanju wrote:hi
can anybody tell me how to empty a hash file?

You can delete the file. It's better for us to explain if you post exactly wat you need.

Thanks,
Veera

Hi, Iam working in datastage 7.5, In one of the job we are processing more than 400 million records which fetches data from seq file and udb stage and feed to UDB stage. we are using copy, filter and sort stage as intermediate to do business validation. I need to reduce the run time of the, Job usu...

chulett wrote:Balajisr has already guided you. Nothing I added fundamentally changed what he said. ...

Yeah thanks chulett.

Use 000 for the quote character on the Format, and use SQuote() function for each field that needs to be quoted. This allows individual fields to be quoted without all string fields to be quoted. ... Hi ray, Thanks for your suggestion. By doing so i can achieve the quotes in the column wherever i w...

chulett wrote:Obviously, they want or need something quoted or this conversation would have been over quite some time ago.

Yeah chulett. We want some of the columns needs to be quoted and the rest needn't.

When writing, 'string' columns are automatically quoted while 'numeric' fields are not. Why not simply try it and see if it works the way you need? ... Hi chulett, I dont want the quotes for string and as well as timestamp column. how do i can achieve this?because by default the column will have do...

When writing, 'string' columns are automatically quoted while 'numeric' fields are not. Why not simply try it and see if it works the way you need? ... Hi chulett, I dont want the quotes for string and as well as timestamp column. how do i can achieve this?because by default the column will have do...

Thanks Craig for your useful alert. :) As i don't have the membership i couldn't see chulett's comment. So could you pls. help me out to get to know. :( :( Thanks in advance, Veera I am sorry.It is not fair to post premium content. Why don't you buy premium membership. Certainly worth it. Hi, Its o...

Ceil() is for parallel jobs only. Do you need this count before the job runs, or as a result from the DataStage job? In the first case get the result of wc -l pathname and subtract ... Ray, I couldn't see your content as am not a member. So could you reply back without that?Your help will be apprec...