DSXchange

Switch_18: Parse error on case string: isin like "A*" = 0, isin like "B*" = 1, isin like "C*" = 2;
multiple `=' tokens were seen.

I tried single quote too.

add it Assume i have added it by using administrator tool. Assume i have also added that variable in my job. But my doubt is how it will get affect while DB insert operation. will adding the variable is enough for commit ? i am little bit confused. There is a logic in Insert Array Size and Row Comm...

can you refer some post's to know about it? I was tired to search about this topic. I don't find anything related to my requirement.

I have searched on the manual (under switch stage). It doesn't say anything about handling wild card character.

Note I have also tried A*. But it didn't worked

any inputs/thoughts pls ?

chulett wrote:

karthi_gana wrote:I have also seen APT_RDBMS_COMMIT_ROWS environment variable in the below link.

http://etl-tools.info/infosphere-datast ... iables.htm

I don't see this variable in my project. !!! ???

Add it.

ok

i thought this will be available by default.

I did

But I don't find any useful information. May be, i am not using the correct keyword to search it.

All, is there a way to identify the server (without asking the ADMIN team) is SMP/MPP/CLUSTER/GRID? i can see 3 nodes in the director log. main_program: APT configuration file: /opt/IBM/InformationServer/Server/Configurations/default.apt { node "node1" { fastname "xxxx.com" pools...

All, As the switch is not working properly, the lights are not glowing and i am unable to watch TV. i am sitting in the dark now. Can anybody fix the issue and help me to watch TV? I am just kidding :) Coming to the issue, I have designed a simple job as below. Seq_File --> Switch --> Seq_1 --> Seq_...

All, I have designed a simple job as below Seq_File --> Copy Stage --> Seq_File1 --> Seq_File2 --> Seq_File3 I left the partition type = auto (default value) as it is. I have read somewhere if we choose/left "Auto", the datastage engine will apply either "Same" or "Round Rob...

I have tried to learn about ODBC stage and its option (like Insert Array Size, Fetch Array Size, Row Commit Interval etc.,). But i don't see this stage in any manual. If anybody knows where i can found more info on this, please let me know. Meanwhile can you explain what is the difference between 'I...

I have also seen APT_RDBMS_COMMIT_ROWS environment variable in the below link. http://etl-tools.info/infosphere-datastage-ee/tutorial/environment-variables.htm I don't see this variable in my project. !!! ??? I can see $APT_ORAUPSERT_COMMIT_ROW_INTERVAL in my project. The dafault value is 5000. We a...

Default log purge setting is "up to last run" to keep logs as small as possible. Override where necessary, but reset to this value when finished testing.

I don't find this option in the RED BOOK too. Where i have set or change this settings? in Director ?

Note: ODBC Connector is the preferred stage type for ODBC.

can you tell me why?

Thanks Craig !

any thoughts on my problem ? Do i need to apply $PROJDEF in all the jobs ?