Search results for query: *

Not sure I understand your question. But if you have a table with three columns... i.e credit_id, proposal_id, credit_index. As in Access database, set credit_id as AutoNumber. In Informix it would be a serial with nulls set to no. By inserting the two other fields, it should increment the...

I'm answering my own question so the next person will have the answer. When I had the selection criteria of (load_date between today and today -6), this returned zero records. But when I changed the syntax to be (load_date between today -6 and today)...it works. This answer was resolved by...

Trying to use the keyword TODAY in the selection tab of InfmxCLI stage. When I use the statement : select * from <table> where load_date = today, directly on the database, I get the desired results. When I try this in datastage, I get zero rows returned. I'm thinking that datastage doesn't...

UPDATE ***** IBM support was not able to give me an answer that resolved our memory issue. After verifying that our configuration should support the number of transaction that I need to process, they suggested adding a sort before my aggregation step to help with the process. Well I could...

Thanks for your help on this... I moved my code into a routine as a case stement as suggested by vmcburney (That worked out very well). The next problem I had was that the job would not compile... but after spending sometime with IBM support, it turns out the the job was currupted and I...

I'm attempting to create a GIANT if.. then... else.... statement in a key expression of a transformation stage. I think there might be a limit to the number of if statements I can put into a single expression. Does anyone know of such a limit? And if so, is there a way to override the...