DSXchange

do you want to capture job log info for rejected records or actual rejected records ?

sudhakar_viswa wrote:Hi,

how to find out howmany records were processed and rejected.I want to store this information into database.

Thanks,
sudhakar

you can use aggregator stage for same , there is utility called aggaregation type "Count Rows".

aaikat wrote:I am a new user of DSEE.Please advise me how should I get the count of records processed by a link. I dont find any built-in routine for that.

there are functions like OpenSeq,CloseSeq,WriteSeq,ReadSeq in BASIC language for file handling, so in same matter Is there any function to create sequential file in BASIC language ?

Yes, Craig Hulett and you both are right, after changing date to varchar it works fine, but can we change something in Adminstrator-projects-NLS-Server Locales -TIME/DATE ? here we have some options that i have tried with different countries' date format however i could not get right one, if u have ...

There are lots of Date and Time functions in Parallel job's guide, please search out in help manual you will get there Hi all, As i am new to Datastage, I want to know that the Functions "Iconv and Oconv" works in Parallel Extender jobs or not. If not which is the equivalent function to th...

Anupam, for each row i am getting same warning message.

sb_akarmarkar wrote:Is it happing to that 2333 row only ? with timestamp value "1998-01-31 00:00:00"

Thanks,
Anupam

I am using Oracle_Oci_9i stage for source and target.If i prefer any oracle stage or ODBC stage despite i am facing same problem.

ArndW wrote:Which stage are you using to write to Oracle? ...

Manually also i entered the record with this format, and it works fine with this date format.

sb_akarmarkar wrote:Why dont you try to insert manually 1 row in target with this date format.... May be one of the way to check format of table...

Thanks,
Anupam

default oracle's date format is dd-mon-yy only,so i have converted it according to target format only.

kumar_s wrote:Are you sure your target formated to dd-mon-yy and not as dd-mm-yyyy?

Yes,default format of date in oracle is dd-mon-yy only, i hv checked it from dual. However here , portfoliodate has been converted to default format only. Are you sure that your default date format is being used? Execute a SQL "SELECT sysdate from dual;" using your favorite tool and see if...

Hello DS Friends, In my job , source and target are oracle tables .source having portfoliodate column and its datatype is TIMESTAMP. for ex its value is 1998-01-31 00:00:00 . while conveting portfoliodate(Timestamp) into target date(dd-mon-yy) format I am using following Iconv,Oconv function. 1)Subs...

Hi,
In Parallel mode i have kept update policy as Overwrite,execution mode is parallel, and its property is default.

ArndW wrote:Have you changed settings in your dataset (execution mode, partitioning, update policy)? Does the log file show that records were going into the dataset? ...

yes, no rows are being written to my dataset

ArndW wrote:But what is not working? Are no rows being written to your data set? Are the values wrong? the row counts? ...

Hi,

Yes this is right that i am not getting any warning or error entries in the log file , so i could not find what is reason to not work with Parallel mode.

ArndW wrote:Hman,

what is the problem you are getting with parallel mode? All you've told us is that you are not getting entries in the log file. ...

Hello, In my application i transfer data from source to target. I have used Sequential file(Source), Modify stage( for change the data type for date to string in one column), Dataset(Target). Mapping is Sequential file --> Modify Stage -- > Dataset. When i keep modify stage in sequential mode job wo...