DSXchange

Hi all,

Is there possibility in DataStage to read binaries data files formatted in some special way.

Best regards,Alexandre Stoulov
------------------------------
Consultant. Business Intelligence Projects
TERN Company
mailto:alexs@tern.ru

When you say "run an SQL statement several times depending on the list of values returned in a previous SQL call" do you mean that the SQL is being executed from your controlling jobs job control routine (via BCI functions), or in the job itself? This will affect the answer; if the first SQL stateme...

Hi, I am coding a controlling job, and I need to run an sql statement several times depending on the list of values returned in a previous sql call. eg. Select Variable1 from TableA where status = PASS I should receive a list of values back from the above command, for each row returned I would like ...

Ive recently Exported / Imported my entire project to a new server. Everything "seems" to be fine, however, Im not able to open a few of my jobs in Designer. I get this error message: This job has no design time information and it will not allow me to open the job. In addition, I have a few jobs tha...

If you have a relational source (like ODBC or UV), there is a lookup property that can be accessed from within the transformer stage with a right-click on the lookup links header. Pick Link Properties, and mark the checkbox "reference link with multi row result set". For every row selected in the lo...

Hi Nuno use for the Table B an ODBC-Stage and set in the Transformer for the Lookup the Link Property "Refernce link with mult row result set" regards Udo Nuno Pimenta on 12.10.2001 10:17:39 Bitte antworten an datastage-users@oliver.com An: "LIST-DataStage (E-mail)" Kopie: Thema: Problem with join H...

Hi all, I have the following problem that i dont know how i can resolve. I have a file (A) that contains numbers, A ( may be 1000 records) Key ---- 1 2 4 ... and i have to join with a table (B) that have 5 millions of records. B (5 millions of records) Key Desc ------------------- 1 A 1 B 1 C 2 A 3 ...

david, 5.1 has been going through betatesting and development for the last few months, obviously during this time information about the new release will have crept out. We will be pushing 5.1 and letting customers know about it very soon, there will be seminars held locally to bring customers up tod...

Very good question ... after similar experiences (and the empty CD in the post trick) I discussed this in some detail with Perry Hayward (European Support Manager) some months ago and flagged that what I (as a user) wanted of support was: a) E-mails whenever new releases occurred. b) Updated media m...

Be also aware of the potential for pure binary integers, which also might be in the file, amongst the other character EBCDIC data. The Packed fields are COMP-3, if cobol is the source, and COMP fields are pure binary (so you need to use the DataTypePicComp transform instead of the DataTypePicComp3 f...

"Brundyn, Pieter" wrote: > It seems to be converting the EBCDIC to ASCII but there are the following problems: > - Do you use the sequential file !?! The mainframe EBCDIC file is binary. > - When do you know when the next row starts? My understanding is that if you have packed decimals in the file, ...

Why doesnt Ascential Software notify their users when a new release is available? Or is my company out of the loop? Through this posting site I have found out about DS 5.1. It seems that Ascential would make a bigger deal of new releases. Also, how do we find out who our SE or AE is? Since the split...

WL> MetaStage 2.2 is not NLS enabled yet. So thats the expected WL> behavior. The WL> upcoming MetaStage 2.3 will have NLS capability. Its expected to be WL> released near the end of the year. There are workarounds sometimes. DataStage 4.x for Sun Solaris does not support NLS also. But it does work ...

Hi. Ive got the mainframe file, and the values are in packed decimal. Do I change the EBCDIC to ASCII and then apply unpacked decimal? Is this possible? Or will it only work if I get the EBCDIC file with the values that are in unpacked decimal after the convert? Pieter -----Original Message----- Fro...

This is a topic for an orphaned message.