DSXchange

Hi psluser

Can you please clarify exactly where you set the NLS_LANG to AMERICAN_AMERICA.AL32UTF8

thansk Ray for the replay..i Need more clarification (what are all stages and functions i need to use ) need apply aggregration on 3 columns. Group_id is same for all rows...need distinct count of CLAIM_ID, count of CLAIM_LINE_ID and sum of amount here is smaple data GROUP_ID CLAIM_ID CLAIM_LINE_ID ...

Hi ,

please help me how to achive this using Aggregator state

CLAIM_ID CLAIM_LINE_ID
1000 1
2000 1
2000 2

I need to get COUNT(DISTINCT CLAIM_ID) AND COUNT(CLAIM_LINE_ID) using Aggregator state

CLAIM_ID_COUNT CLAIM_LINE_ID_COUNT
2 3


Thanks in advance

Chulette quote=double and quote='^' both work now that i have removed INTACT. With INTACT i was getting the following error message (see bold) - ^DMX MUSIC^|^Ch 01 S^|^OVERTURE to DER FREISCHUTZ (1817-21)^|^KUHN/STAATSKAPELLE DRESDEN/WEBER^|^CARL MARIA VON WEBER: OUVERTUREN^|^cpo^|^10052 1985^|^cpo ...

ugh ...

Removed INTACT from the schema file and problem solved ....
Marking the thread as resolved.

If anybody has any idea why that solved the problem let me know. The documentation on schema file is very sparse especially on variable length files.

Hi I am at the end of my wits trying to figure this out. So Help me please. I have a simple variable length text file that uses pipe (|) as field delimiter and double quotes(") as text qualifier. Here is a sample record - "DMX MUSIC"|"Ch 01 S"|"OVERTURE to DER FREISCHUT...

Ah ...thanks Chulett ...
I didn't realize it was only for the repository. Great idea about the loop.
Thanks again.

Hi I am looking to purge all my log files. My logs are being kept in the RT_LOGnnn files instead of in the repository. From the following article i found a command that wakes up every 30 minutes to purge about 10000 logs. http://www-01.ibm.com/support/docview.wss?uid=swg21370048 The command is - ./L...

Thanks for that bit of info Ray. Much appreciated.

Hi Just wanted to let you know that i used DS.Checker and syncproject and nothing bad was found. But working on my suspicion that it had something to do with the large number of warnings being generated, i made changes to the code to remove the warnings and that fixed it. The job now runs without a ...

Thanks asorrell

So does that mean that these error are only the DS director client issue and the job is executing fine ?

Let me see what happens when all the rows are loaded ...about 4 million so far ...

Just ran it again after deleteall/re-import/recompile cycle ... and this time getting different errors - Error calling subroutine: DSR_EXECJOB (Action=5); check DataStage is set up correctly in project PrepBatch (The connection is broken (81002)) and Error calling subroutine: *DataStage*DSR_PROJECT ...

Hi
Thanks...i will try it ..

Just a question. This job is generating enormous amounts of warnings ...is it possible that so many warnings somehow corrupt the files that are associated with this job causing this weird error ?

Hi I am facing a strange problem while running a job. Let me explain the process a little bit. We have data in sql server that needs to be loaded into oracle. We load the following 3 tables - Header (primary key H1, also has a column X1) Detail_1 and (primary key D1, foreign key H1, also has column ...

Thanks Craig. I looked and looked and looked and finally found these two that i could use in 8.1 8.5 has a much more comprehensive set available. TimestampFromDateTime(datePart, timePart) and TimestampFromSecondsSince(1, timestampValue) --increments timestamp by 1 second. I Defined DatePart = '2013-...