DSXchange

The job flow: sequential file=>transformer=>dataset The input SQL Type : varchar(14) The output SQL Type: timestamp The deviration logic in the transfomer: If Trim(DSLink10.ColTimestamp) = "" Or IsValid("timestamp", StringToTimestamp(Trim(DSLink10.ColTimestamp) ,"%yyyy%mm%dd...

Try this: copy the env variable secions from one DSParams and Paste into the new DSParams. DSParams is a file in the project folder. Hi How to migrate environment variables (user defined) from one environment to other? I did export and import of the project. It imported everything except user define...

Thanks for your direction, Ray. Do you know where I can get documentation about this?

ray.wurlod wrote:You can create a job-specific message handler to demote these warnings to informational. ...

Hope you could help out with my second issue :) My job design is like: sequencial file stage=>transformer=>dataset the sequencial file is fixed-width, timestamps are in the format: YYYYMMDDHHMISS, for example, 20070227124900 and are filled with spaces where optional. The SQL Type in the sequencial f...

I found that option. Thanks. Next time I should do more research before posting.

balajisr wrote:Sequential file has a option named "Row Number Column" which will generate row numbers starting with 0.

Thank you for prompt reply. Could you please suggest where I can add the running number column? In sequencial file or transfer stage?

DSguru2B wrote:Add another column that has a running number. This way when it gets rejected, you will have the row number right there with the row.

My job is required to get the row number for the rejected rows in order to link them back to the sequencial file. But for my understanding, the data is partitioned after the sequencial file is read into DataSet and passing to the next stage. I probably can get the @INROWNUM and @PARTITIONNUM in a tr...

Does anybody know if there are MetaBrokers for ERwin r7 and Cognos 8? Our project has requirements to integrate MetaData into MetaStage 7.0 from ERwin r7 and Cognos 8. Or is there another way to do the import? e.g. export MetaData from ERwin r7/Cognos 8 into XMLs and then import into MetaStage. But ...

Thank you, Ray. Then I guess there is something wrong with my configuration. When I directly imported into MetaStage from DS7.5, MetaStage didn't show up when I choosed the Directory Name and typed the schema name/password. The second error I had is that a pop up dialogue window which said "unk...

I am new to MetaStage. Our project is using: DataStage Enterprise Edition 7.5.2 MetaStage 7.0.1 DataStage 7 MetaBroker Is it possible to import Meta Data into MetaStage 7.0.1 From DS 7.5.2? I tried: 1. Directly import 2. Import via MetaBroker But both failed. Does it work if we only upgrade the Data...

PRESERVE BLANKS Option The PRESERVE BLANKS option: 1. Retains leading whitespace when optional enclosure delimiters are not present 2. Leaves trailing whitespace intact when fields are specified with a predetermined size For example, consider the following field, where underscores represent blanks: ...

I have never used MF stages, but the author said he tried to use ODBC stage...

Would be insterested in learning something about MF stages

BigFoot wrote:the tables are in the source...

I also tried the same thing in MF(ODBC stage) but it didn't work.

Thanks

POSITION(1:11) I just realized this is a control file for fixed-width format...I believe APT_STRING_PAD_CHAR is used when the Enterprise Stage generates the data file. That's why additional spaces appears in both fields if PRESERVE BLANKS is set to true. Set APT_STRING_PAD_CHAR to NULL (0x00) and PR...

If you are very sure it's not concerned with UNIX permission, check the file name quotation: DataStage reads your command and may interpret and pass a different command to UNIX. For example, './u2dtmpkESNiS' and "./u2dtmpkESNiS" are different things to UNIX and the last one is what you are...

I didn't try but just give you a hint: You said you are using ODBC stage, then use user-defined SQL and follow the syntax of standard SQL for column aliasing. Have you tried just SELECT SCHEMA.TABLE1.FIELD1 ABC..... i also tried that...but :( if you specify a valid alias in the SQL, that will be pas...