DSXchange

If your source is a sequential file and you are very sure that you are going to get Numerical values the you can defined Decimal(20,0) at source itself.

You can check if you have anything defined for Oracle like lib, bin file path in .profile of dsadm so same need to defined for new unix-user and you can check if new user has read-execute permission on the directories where Oracle client has been installed on Unix box.

ArndW wrote:Maintenance of the &PH& directory log files is/was an oversight in DataStage since version 1. You can remove the contents from UNIX, so a simple script could remove any files older than a week ...

Thanks a lot

Regards,
Nitin Swarnkar

Hi Everyone,

In my project there are 5435 file in &PH& directory, and the number is keep increasing, Is there any way by which these entries get purged automaticaly. and what if i delete all the entries.

Thanks in advance.

Regards,
Nitin Swarnkar.

[quote="mouthou"]Hello everyone, I have 100s of columns in a file taken from a mapping spreadsheet as shown below. Hi, as you mentioned you have 100s of columns so create a temporary table in temp schema scott schema and then you can import the metadata definition from that table. Regards,...

[quote="asitagrawal"]Hi Friends, In my database, the Decimal values use comma(,) instead of deciaml points (.). The values when read in DataStage hence treated as String (e.g -15,89 which actualy is -15.89). Hi Asit, You can use following function Ereplace(Arg1,char(44),char(46)) Arg1 is t...

i have recently uninstalled 7.5.1A client and installed 7.5 client, now i am not able to open job activity, routine activity properties in seq job. is it compatability issue or what can anyone throw some light. thank you Hi, I have faced similar problem when my machine windows XP OS. then i have ch...

THANK YOU VERY MUCH.

kumar_s wrote:Hi,
There are several ways. Do a search.
@INROWNUM/@OUTROWNUM functions can be simply used to keep track of the number of records being passes across transformer.

Thank you very much i think DSJE.LINKROWCOUNT is a good solution. Being new to DataStage, some of the advice you'll get will probably sound like Greek. If so, try taking the keywords and searching the forums here as pretty much any question you'd have has already been asked and answered. :wink: Two ...

Hi, I am new to Datastage, I want to track the no. of records that have been passes through the transformar to the file or table in a separate file. Basically job log in director having that count like J3RmsS4Lor..T: DSD.StageRun Active stage finishing. 8756128 rows read from ToT 8756128 rows writte...

kcshankar wrote:Hi swarnkar,

Make File1 as source and do lookup on File2 and File3 for key column1 and 2 and get the remaining fields.
Or use Merge stage to do the same.

Regards
kcs

But with this approach i will miss the records which are in file2 and file3 but not in file1

[quote="keshav0307"]I find it straight farwords

SQFILE---->stored procedure------->file

Keshav,
stored procedure stage is available in Data Stage 7.5 so its ok for them but for prior versions we have call SP trough OCI or ODBC stage

Thanks

Hi, I have to create a job in which i have to extract data from three different tables and create a seq file. These files having six columns each and out which 2 columns are common. Now depending on the these 2 key columns i have to create a files having column of all three files. Like File1 01,A,19...

Hi, You can call it through ODBC stage as SEQ_FILE----->Tranfomer------>ODBC_STAGE the input column to ODBC_STAGE will be passed as agrument to procedure. Here agrument is compulsary so if yoour procedure is not using arguments, you can pass a dummy agrument. You can call SP in OCI stage where you c...