DSXchange

Hi all,

Maybe someone can help answer this question. Is it possible to return data from a Hash File where the keys are equal except the date where it is less than or equal to the date of the source? Or is my only solution to use bind variables and use user defined sql?

Thanks

Not sure if I should have started a new topic for this, but it is an issue related to bind variables. Does anyone know how I can compare two bind variables to each other in user-defined sql? I'm getting an error that I cannot compare ? = ? and I read that I need to use a cast statement on one of the...

Thanks for the help! The problem was with the sql statement and not the bind variables. By the way, is it possible to use the numbered bind variables in db2 user defined sql or is that an oracle uniqe capability?

Hi, Can someone help me understand how to use the '?' in user-defined sql? I have a job that has a lookup joining 3 tables. One of the tables in the lookup is also the source table, so I am using the '?' to qualify source against lookup. My problem is when I try to run this job, my lookup returns no...

Well, you guys were right. There was a data mismatch in the hashed file. I needed to place a transformer between the drs and hashed file to truncate the seconds from my timestamp. When I did this, the lookup worked fine. Thanks for the help everyone!

There are 5 keys with a char, date, smallint, smallint, and char datataypes. I am using LTRIM(RTRIM in the derivation in drs stage and TrimF(TrimB( on the key expression in the transformer. Something else I forgot to mention. I am joining 2 tables in the drs stage to populate the hash file. Will thi...

All the data types are correct. I'm unsure of what you mean by check if your partitioning is correct? Sorry, but can you explain that please? The lookup file actually has data in the input and oddly enough output. But for whatever reason, it won't match the source. Also, I tried to run just the sour...

Hi, Maybe someone can keep me from going insane here. My lookup fails for all rows when I know there are definitely rows that match between the source and lookup. The source is a drs stage connecting to DB2. My lookup connects to db2 via drs first and passes the dataset to a hashed file then to the ...

Well, by giving me access to DataStage Client on a different server, I am able to compile successfully. Not sure if I'll ever find out why it stopped working on the other server, but as you guys have said, something must've changed that they couldn't figure out. Anyway, thanks for the help!

Well, I checked with the administrators again and they said all the users have proper write permissions. This is not something I have the power to check myself but when this problem arose before they were able to correct it by giving write permissions, so I can only assume they know what they're tal...

To follow up, we are using Citrix to connect to the Ascential client. Which username is the one that needs write permissions? Is it the username used to connect to the Ascential Server or the username used to connect to Citrix?

Thanks in advance!

Hi all, I'm getting the following error when trying to compile a Sequencer: <JobSeqGenError> <Code>2017</Code> <Desc>XML parser error on input line 0: source='', reason=''</Desc> <LineNum>0</LineNum> <Line></Line> <Ref></Ref> <Version>7.5.0.25</Version> </JobSeqGenError> I've seen this error earlier...

Internal format will work only if its defined as Date in the target database. If its timestamp then internal format wont work. Try Ray's suggestion, which is the same as Ken pointed out. If that doesn ... Yep, Ray's suggestion did work and you are correct about it having to be the Date datatype in ...

There are Transforms for extracting the date portion of a Timestamp, or you can use Field(InLink.TheTimestamp, " ", 1, 1) or Left(InLink.TheTimestamp, 10)[ ...[/quote] Hi Ray, I tried the Field function and it does truncate my timestamp fine leaving the date how I want it: YYYY-MM-DD. How...

DB2 plugin works differently than Oracle or ODBC stages. If the datatype is DATE, the plugin will silently do an ICONV coming and OCONV going. Change the metadata in the job to TIMESTAMP and see if your problem goes away. In the future make sure you always change your metadata. Otherwise, just put ...