DSXchange

I would like to know about The Data Warehousing Institute(TDWI) - membership. Is it useful? Please post your thoughts

I am looking for a cognos developer network info.. (similar to dsxchange which specifically discuss "Cognos stuff")

Pl. let me know....


I AM REALLY SORRY TO POST THIS QUESTION HERE... (beacuase I don't know better place to post..)

I have two date column, how do i derive number of months between two dates

I have to implement the following scenario, 1) Step 1: select list of emp_no from <TABLE1> ... .... ... n) Last Step : I have to run multiple SQL statment against various tables in one database in DB2 Stage (using DB2/UDB API plug in) Ex: insert into <TABLE2> VALUES (emp_no,......) delete from <TABL...

I am trying to develop a POC which take input datafiles in XML format. 1) I have a sample XML file and able to import the meta data. no issue 2) I want to read the XML file as input data file and write to a sequential file. Could you pl. tell me how to do that. What "stage" I have to use t...

I am getting an input data file in the following format {1111111111111111 :22222 :3333333 :44444444 :55 :66 -} { ................... -} Need to transform into (merge multiple line into ONE record.. number of lines has to be merged is always constant 7 , first line { and 7th line -} {1111111111111111...

I am creating a data model to create Relation Schema (DB2 - UDB). Lot of required information available as Cobol Copybook. Is there any Utility avaialbe to convert the Cobol Copy book into SQL (Create table) statment.....


Thanks,
Muru

I am getting a input file with header/detail/and fooder EXample <HEADER_STR><ORDER_NUM><HEADER_DATE> <DETAILA><ORD_DETAIL_NO1><QTY> <DETAILA><ORD_DETAIL_NO2><QTY> <DETAILA><ORD_DETAIL_NO3><QTY> <TRAILER><ORDER_NUM> Output file should be <ORDER_NUM><HEADER_DATE><ORD_DETAIL_NO1><QTY> <ORDER_NUM><HEADE...

I have to take an input file INPUT_<MMDDYY99>.EXT and process it
and save the output in OUTPUT_<MMDDYY99>.EXT

How I can implement this .... Any help?

I am working on a prototype using CFF stage. If I have 88 level in cobol copy book then It couldn't read the record correctly. but it didn't raise any error. If you are using cobol file definition, remove 88 level in copy book and import the definition and re-compile/run the job. See whether this is...

I have 3 output link in one transformer stage. In one link I want to take only the last row. I need to ignore all other rows. Is there any way to exclude all rows except the last row using constraint or any other method.....

from one transformer stage sending records to TWO different Sequential file(FILE1 & FILE2). I want to write the record count of FILE1 and FILE2 in a status file in the following format. Date,File1_record_count,File2_record_count 1/1/04,27,35 Now I am using two aggregator to derive the count for ...

I have to generate a output file in CSV format and String MUST NOT be enlcosed by Quotes. In a Sequential File Stage --> Fromat Tab -->Quote character is expecting a character, I couldn't proceed without a value in Quate character.

Any help....

I have to suppress the leading 0

Example

input output

00000123.2340 => 123.2340
00012345.6700 => 12345.67
12345678.9801 => 12345678.9801

how do I implement this in fmt function?

Thanks,

Is there any other way EXCEPT using FTP Stage to read and write datafile from remote server in a DataStage Server Job


DataStage Server is running on UNIX server
Source/Traget files reside in WindowNT server