DSXchange

Sorry, in my sample code, it should have been a "Not(IsNull(...))". Tony Curcio wrote: The way I would do this is to define several hash lookups wach for the same file while varying the "Key Derivation". The first lookups derivation would be "inputlink.inputfield[1,1]" to check for a match for the f...

Hi Alexandre, you can get substring of the STREAM_CODE by editing key expression (i.e. [1,3]): the place where you "put" the STREAM_CODE for lookup. I hope this can help you. Riccardo ----- Original Message ----- From: "Alexandre Stoulov" To: Sent: Tuesday, October 16, 2001 4:12 PM Subject: Lookup q...

The way I would do this is to define several hash lookups wach for the same file while varying the "Key Derivation". The first lookups derivation would be "inputlink.inputfield[1,1]" to check for a match for the first character. The second lookups derivation would be "inputlink.inputfield[1,2]" to c...

Hi all, Does anybody knows how to solve this task: I have an input stream (flat file) that contains character field STREAM_CODE. One value for this field for example "823102". Also I have a lookup table (hash file) with lookup key field LOOKUP_CODE that contains values: "821", "82","823","8233". The...

What is the data type when you import metadata from the UDB tables? Whatever it is, this is the type you should use. If you really are doing BCI function calls (which your reference to "SQLBindCol and SQLBindParameter calls" suggests), why not use SQLColumns, SQLColAttributes, SQLDescribeCol and, pe...

Hi! I use DataStage V4.1 and UDB V7.2. When I code a job with DataStage Basic, I get problems with the datatype. In my UDB table there is a field defined as character for bit data. I would like to move this field from the source table to the target table. layout of UDB tableA (source table): FieldA1...

Can datastage read realtime of a mainframe ? (db2) Does it require a plugin ? We are currently using Datastage V4.0 Thanks Pieter NOTICE: This message contains privileged and confidential information intended only for the person or entity to which it is addressed. Any review, retransmission, dissemi...

Another question - are you using the same versions ? I had a problem where my client and server versions were not compatible, and I could not open jobs - even ones I created through the same client. When we changed the versions the problem was solved. This is probably not the case here, but I though...

Lisa - Are you sure that your export ran to completion?? At any time during the export did a box appear that said that a certain job couldnt be exported because it was in use? The way the export works, if a job is "in use" (which means someone could have it open in the designer, or even that an old ...

Thanks a lot Wolfgang and all who has answered. Your answers are very helpfull. Best regards,Alexandre Stoulov ------------------------------ Consultant. Business Intelligence Projects TERN Company mailto:alexs@tern.ru whgd> If you look into the helpfiles you will find for sure functions to whgd> co...

This is a topic for an orphaned message.

Dont know about Datastage, but the syntax I use for this query in Informix is: SELECT a, MAX(b) FROM tabA GROUP BY a HAVING MAX(b) in (SELECT c FROM tabC ) You cannot use = because "select c from tabc" can return more than one row Hope this helps Dirk -----Original Message----- From: Nuno Pimenta [m...

Hi all, Im using InfmxCli and i cant execute a query like that: SELECT a, MAX(b) FROM tabA GROUP BY a HAVING MAX(b) = SELECT c FROM tabC It gives the follow message: [Informix] [Odbc Informix Driver] General error. Syntax error, SQLExecute: Failed to execute statement. If i use: SELECT a, MAX(b) FRO...

The sources for this data files are telecom devices and contain information about traffic passed. It may be duration, price, direction and so on. The one bit parsing must be done to load them to the database. Does UvBasic contains functions for processing bits? As I understand the minimum piece of d...

This is a topic for an orphaned message.