DSXchange

Hi,
I created a hash file and later look it up on a sequential file. I have a missing record. Its just missing 1 record in the lookup. What would be the reason. Any guesses???
Thanks
Sam

Hi, I have to FTP a GDG file from mainframe. Everything works fine when I give the GDG number in the remote file name field and the DataSet name in the remote path name field of the FTP Stage, but when i give LD(0) in the remote file name in the FTP stage it doesnt work. How do I go about to get the...

I have the VOC pointer and can see the selection Tab on the Hash File stage but I cannot click it. Its like locked, what can be the reason.
Thanks
Sam

You need Admin rights. :D

Now Iam dense... :) For Ex: HashA HashB HashC Col1 Col1 Col1 text1 text3 Text1 text2 text1 Text4 The output I need is HashOutput Col1 Col2 text1 A text2 A text3 B text1 B text1 C text4 C How can this be acheived other than going for 3 different jobs. Thanks. Sam

Try this U have to execute it on the command line interface in Admin else u can telnet into the server and in the uv shell execute this commands.
[/code]

I have 5 hash files with a single column. Iam trying to merge all these files into a single file and associate a type value in the target hash file. The value coming from hash file 1 can have a type value as 1 and value coming from second hash file can have a value of 2 in addition to the hash file ...

Hi, I wanted to know how we can load from multiple hash files, having a single column into another hash file having that column and a coresponding type column which would have a hard coded value for the column coming from each hash file. For ex. if we have 5 source hash files then the target hash fi...

I have the client and server both on Win XP, I got the count of the hash file by creating a VOC entry by using SETFILE and getting the count through the Admin Command window. The same is true for getting the info through the UV shell. I could also query the hash file successfully. I wanted to get th...

Guess I have to RTFM. Thanks!

Geez!!! forgot you were in australia. I got the value from the function as 54190.773 which was similar to the output of Time() . I guess windows cant give me more than millisecs. Also 10/3 gives 3.333333333. So what does that mean about the datastage Precison . Can you explain about it. Thanks for t...

Ray can you shed some light on generating a seconds of 6 precision in datastage and loading it to teradata or SQL. Iam right now able to acheive a degree of 3 using the above logic. I read in a previous post of generating a 8 digit random number following the seconds of the TimeDate() for uniqueness...

Thanks Craig, I did figure out by searching through the forum. I used And this works perfectly.
SAM

Thanks for all the replies. I used TimeDate() function and I could generate the timestamp. But i need the precison to 1/1000th sec like 2000-08-06 01:29:12.717 in SQl and in teradata too. Iam getting the timestamp like this 2004-11-24 08:53:52 using Oconv(Date(), "D-YMD[4,2,2]") : " &...

Hi,
I need to generate timestamp in datastage and store it in SQL and also in Teradata. Which would be the best way of generating the timestamp and be consistent with the format with what we see in SQL and Teradata.
Thanks.
SAM